== PostgreSQL Weekly News - October 20 2013 ==

== PostgreSQL Weekly News - October 20 2013 ==

PgDay Argentina 2013 needs money. Please give.
http://www.postgresql.org.ar/pgday2013/crowdfunding?lang=en

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.
https://github.com/jmafc/Pyrseas

== PostgreSQL Jobs for October ==

http://archives.postgresql.org/pgsql-jobs/2013-10/threads.php

== 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:
https://wiki.postgresql.org/wiki/Pgconf_cn2013
Registration:
http://bbs.pgsqldb.com/client/bm.php

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

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

The fourth edition of the Argentinian PostgreSQL Day will be held on
November 14 2013 in Buenos Aires, Argentina.
http://wiki.postgresql.org/wiki/PGDay_Argentina_2013

PGDay Cuba will be in November, 2013.
http://postgresql.uci.cu/

== 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 david(at)fetter(dot)org, German language
to pwn(at)pgug(dot)de, Italian language to pwn(at)itpug(dot)org(dot) Spanish language
to pwn(at)arpug(dot)com(dot)ar(dot)

== 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.
http://git.postgresql.org/pg/commitdiff/05a0283e7a48ffdca96cb6dd94fa5bae06e29bd1

- 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
http://git.postgresql.org/pg/commitdiff/e5158613676d940cf71ecfb5c73ac933746ac847

- 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
http://git.postgresql.org/pg/commitdiff/d41ab71712a4457ed39d5471b23949872ac91def

- 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.
http://git.postgresql.org/pg/commitdiff/81051a86bcecdc681592725139fe610b2c1d1428

- 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.
http://git.postgresql.org/pg/commitdiff/ea91a6be89575095f61ebf36d67c2df98be093db

- 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.
http://git.postgresql.org/pg/commitdiff/523beaa11bdf6a9864e8978b467ed586b792c9ca

- 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
http://git.postgresql.org/pg/commitdiff/cab5dc5daf2f6f5da0ce79deb399633b4bb443b5

Bruce Momjian pushed:

- docs: correct 9.1 and 9.2 release note mention of timeline switch
fix. Backpatch through 9.1. KONDO Mitsumasa
http://git.postgresql.org/pg/commitdiff/f918c52f65aa28fb8c00d3f7078ff7b4788929dc

- Allow 5+ digit years for non-ISO timestamp/date strings, where
appropriate. Report from Haribabu Kommi
http://git.postgresql.org/pg/commitdiff/7778ddc7a2d5b006edbfa69cdb44b8d8c24ec1ff

Peter Eisentraut pushed:

- doc: Enable book index in XSLT builds. The XSLT toolchain requires
an empty <index> element where the index is supposed to appear. Add
that with conditionals to hide it from the DSSSL build.
http://git.postgresql.org/pg/commitdiff/90c7b7d16bb3a90fc9168ff8942fbf78308e727d

- 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.
http://git.postgresql.org/pg/commitdiff/63f32f3416a8b4f8e057dc184e8e8eae734ccc8a

- 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.
http://git.postgresql.org/pg/commitdiff/ed632ab21e9c638328498a85ccf77452645943bb

- Fix for lack of va_copy() on certain Windows versions.
Based-on-patch-by: David Rowley <dgrowleyml(at)gmail(dot)com>
http://git.postgresql.org/pg/commitdiff/c2316dcda1cd057d7d4a56e3a51e3f8f0527e906

- Add libpgport to isolationtester on MSVC. From: Asif Naeem
<anaeem(dot)it(at)gmail(dot)com>
http://git.postgresql.org/pg/commitdiff/595a6a035008cfa76faa2f284e91704f18673d13

- Switch order of libpgport and libpgcommon in MSVC build as well
http://git.postgresql.org/pg/commitdiff/3c093b4ad267bbba1bc1e403719dddb881d2696e

- Move pgfnames() from libpgport to libpgcommon. It requires
pstrdup() from libpgcommon.
http://git.postgresql.org/pg/commitdiff/ba7c5975adea74c6f17bdb0e0427ad85962092a2

- Move rmtree() from libpgport to libpgcommon. It requires pgfnames()
from libpgcommon.
http://git.postgresql.org/pg/commitdiff/2e6bc4b806ca92433932b34c019293a201f03e11

- Add *.pot to .gitignore
http://git.postgresql.org/pg/commitdiff/07bf70356c4a22939dfd89f3fb48d1a50c901e13

- Add libpgcommon to backend gettext source files. This ought to have
been done when libpgcommon was split off from libpgport.
http://git.postgresql.org/pg/commitdiff/713a9f210d5cf5d94cc420b01eef5183569402e0

Alvaro Herrera pushed:

- Silence compiler warning when SSL not in use. Per Jaime Casanova
and Vik Fearing
http://git.postgresql.org/pg/commitdiff/86029b31e5c71be5f9aceba0da2c609496435418

Andrew Dunstan pushed:

- Return valid json when converting an empty hstore. Oskari
Saarenmaa.
http://git.postgresql.org/pg/commitdiff/bbe4deac1b98594206a024c9e91d664b3c3410d9

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.
http://git.postgresql.org/pg/commitdiff/709170b790c11b4012004a6baf11a0fc6ec950de

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

David Fetter sent in another revision of a patch to allow CREATE
FOREIGN TABLE (... LIKE ...).

Andres Freund sent another flock of patches for logical changeset
generation.

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
architecture.

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
pg_stat_statements.

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.