Features Download
From: David Fetter <david <at> fetter.org>
Subject: == PostgreSQL Weekly News - October 20 2013 ==
Newsgroups: gmane.comp.db.postgresql.announce
Date: Monday 21st October 2013 05:20:58 UTC (over 3 years ago)
== PostgreSQL Weekly News - October 20 2013 ==

PgDay Argentina 2013 needs money.  Please give.

Commitfest II for the 9.4 cycle has ended with excellent progress
through the patch queued.  Twenty patches were pushed, some quite
significant in scope.

== PostgreSQL Product News ==

Pyrseas 0.7.0b1, a toolkit for PostgreSQL version control, released.

== PostgreSQL Jobs for October ==


== PostgreSQL Local ==

The Italian PGDay (PGDay.IT) will be held on October the 25th in
Prato, Tuscany, Italy, at Monash University Center.
To register to the event or get information about the accepted talks
and schedule please see the official web site: http://2013.pgday.it

The PostgreSQL Conference China for 2013 will be held October 26-27,
2013 in Hangzhou.  Chinese language information here:

pgconf.EU 2013 will be held on Oct 29-Nov 1, 2013 at the Conrad Hotel
in downtown Dublin, Ireland.  Registration is open.

PGConf.DE 2013 will be held November 8th, 2013, at the Rhineland
Industrial Museum in Oberhausen.  The CfP is open through September
15, 2013.

The fourth edition of the Argentinian PostgreSQL Day will be held on
November 14 2013 in Buenos Aires, Argentina.

PGDay Cuba will be in November, 2013.

== PostgreSQL in the News ==

Planet PostgreSQL: http://planet.postgresql.org/

PostgreSQL Weekly News is brought to you this week by David Fetter

Submit news and announcements by Sunday at 3:00pm Pacific time.
Please send English language ones to [email protected], German language
to [email protected], Italian language to [email protected]  Spanish language
to [email protected]

== Applied Patches ==

Robert Haas pushed:

- Fix details missed by dynamic shared memory patch.  Additional
  documentation update, and a comment fix.  Both issues reported by
  Amit Kapila.

- In dsm_impl_windows, don't error out when the segment already
  exists.  This is the behavior of the other implementations, and the
  behavior expected by the callers of this function.  Amit Kapila

- initdb: Suppress dynamic shared memory when probing for
  max_connections.  This might not be the right long-term solution
  here, but it will hopefully turn the buildfarm green again.
  Oversight noted by Andres Freund

- Remove spinlock support for SINIX, Sun3, and NS32K.  All of these
  platforms are very much obsolete.  As far as I can determine, the
  last version of SINIX, later renamed Reliant, occurred some time
  between 2002 and 2005.  The last release of SunOS that would run on
  a sun3 was released in November of 1991; the last release of OpenBSD
  which supported that platform was in 2001.  The highest clock speed
  of any processor in the family was 25MHz.  The NS32K (national
  semiconductor 320xx) architecture was retired in 1990.  Support can
  be re-added if a maintainer emerges for any of these platforms, but
  it seems unlikely.  Reviewed by Andres Freund.

- Remove IRIX port.  Development of IRIX has been discontinued, and
  support is scheduled to end in December of 2013.  Therefore, there
  will be no supported versions of this operating system by the time
  PostgreSQL 9.4 is released.  Furthermore, we have no maintainer for
  this platform.

- Provide a reliable mechanism for terminating a background worker.
  Although previously-introduced APIs allow the process that registers
  a background worker to obtain the worker's PID, there's no way to
  prevent a worker that is not currently running from being restarted.
  This patch introduces a new API TerminateBackgroundWorker() that
  prevents the background worker from being restarted, terminates it
  if it is currently running, and causes it to be unregistered if or
  when it is not running.  Patch by me.  Review by Michael Paquier and
  KaiGai Kohei.

- Allow only some columns of a view to be auto-updateable.
  Previously, unless all columns were auto-updateable, we wouldn't
  inserts, updates, or deletes, or at least not without a rule or
  trigger; now, we'll allow inserts and updates that target only the
  auto-updateable columns, and deletes even if there are no
  auto-updateable columns at all provided the view definition is
  otherwise suitable.  Dean Rasheed, reviewed by Marko Tiikkaja

Bruce Momjian pushed:

- docs: correct 9.1 and 9.2 release note mention of timeline switch
  fix.  Backpatch through 9.1.  KONDO Mitsumasa

- Allow 5+ digit years for non-ISO timestamp/date strings, where
  appropriate.  Report from Haribabu Kommi

Peter Eisentraut pushed:

- doc: Enable book index in XSLT builds.  The XSLT toolchain requires
  an empty  element where the index is supposed to appear.  Add
  that with conditionals to hide it from the DSSSL build.

- Switch order of -lpgport and -lpgcommon.  Conceptually, libpgcommon
  can depend on libpgport, but not the other way around.  In the past,
  this might not have mattered, but it's needed now for asprintf.

- doc: Configure TOC generation in XSLT HTML build.  The default table
  of contents in the XSLT HTML build is much too big and deep.
  Configure it to look more like the one that is currently being
  produced by the DSSSL build.

- Fix for lack of va_copy() on certain Windows versions.
  Based-on-patch-by: David Rowley 

- Add libpgport to isolationtester on MSVC.  From: Asif Naeem

- Switch order of libpgport and libpgcommon in MSVC build as well

- Move pgfnames() from libpgport to libpgcommon.  It requires
  pstrdup() from libpgcommon.

- Move rmtree() from libpgport to libpgcommon.  It requires pgfnames()
  from libpgcommon.

- Add *.pot to .gitignore

- Add libpgcommon to backend gettext source files.  This ought to have
  been done when libpgcommon was split off from libpgport.

Alvaro Herrera pushed:

- Silence compiler warning when SSL not in use.  Per Jaime Casanova
  and Vik Fearing

Andrew Dunstan pushed:

- Return valid json when converting an empty hstore.  Oskari

Noah Misch pushed:

- Consistently use unsigned arithmetic for alignment calculations.
  This avoids an assumption about the signed number representation.
  It is anticipated to have no functional changes on supported
  configurations; many two's complement assumptions remain elsewhere.
  Per a suggestion from Andres Freund.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Fetter sent in another revision of a patch to allow CREATE

Andres Freund sent another flock of patches for logical changeset

Vik Fearing sent in another revision of a patch to document how and
when subqueries can modify data.

Vik Fearing sent in another revision of a patch to allow stats
collection for the CLUSTER command.

Robert Haas sent in a patch to remove support for the Alpha

Tomas Vondra sent in two versions of a patch to add flow charts for
the FDW API.

Vik Fearing sent in two more revisions of a patch to add
pg_sleep_for(interval) and pg_sleep_until(timestamptz).

KONDO Mitsumasa sent in two approaches to a patch to improve

Rajeev Rastogi sent in a patch to ensure that COPY FROM STDIN shows a
count tag, which it did not before.

Fabrízio de Royes Mello sent in another revision of a patch to enable
time-delayed standbys.

Dean Rasheed sent in another revision of a patch to allow tab
completion for views and foreign tables in psql.

Peter Geoghegan sent in a patch to create an autovacuum_work_mem GUC.

Nigel Heron sent in a WIP patch to keep track of the number of bytes
sent and received by the server over its communication sockets.

Sent via pgsql-announce mailing list ([email protected])
To make changes to your subscription:
CD: 3ms