== PostgreSQL Weekly News - September 15 2013 ==

== PostgreSQL Weekly News - September 15 2013 ==

The second PostgreSQL CommitFest of the new development cycle has
begun.
https://commitfest.postgresql.org/action/commitfest_view/inprogress
http://wiki.postgresql.org/wiki/Reviewing_a_Patch
https://commitfest.postgresql.org/action/commitfest_view?id=19

== PostgreSQL Product News ==

PG Partition Manager 1.4.0, an extension to manage time- or
serial-based table partitioning, released.
https://github.com/keithf4/pg_partman

Slony-I 2.2.0, a trigger-based replication system for PostgreSQL, released.
http://www.slony.info/

== PostgreSQL Jobs for September ==

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

== PostgreSQL Local ==

Open Source Software for Business" (OSS4B) 2013 will be held in Prato,
Tuscany, Italy on September 19 and 20. Registration is open.
http://www.oss4b.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

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

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. The CfP is open.
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:

- Introduce InvalidCommandId. This allows a 32-bit field to represent
an *optional* command ID without a separate flag bit. Andres Freund
http://git.postgresql.org/pg/commitdiff/71901ab6daaad65c0168c05e016e4208efe5b71a

Peter Eisentraut pushed:

- Show schemas in information_schema.schemata that the current has
access to. Before, it would only show schemas that the current user
owns. Per discussion, the new behavior is more useful and
consistent for PostgreSQL.
http://git.postgresql.org/pg/commitdiff/b34f8f409bec4921d260ac84668917f5fff04319

- Fix typos
http://git.postgresql.org/pg/commitdiff/cdeb79adcfb2e46efd4f76c39184dd452ae1acd0

Fujii Masao pushed:

- Remove leftover function prototype. The prototype for
inval_twophase_postcommit wasn't removed when it's definition was
removed in efc16ea520679d713d98a2c7bf1453c4ff7b91ec / the initial
Hot Standby commit. Andres Freund
http://git.postgresql.org/pg/commitdiff/71129b6fc5a7f1a7615f9ee07ee55994217de994

Bruce Momjian pushed:

- psql: honor 'footer' option for expanded output. "No rows"
previously only honored the tuples-only option. Per report from Eli
Mesika
http://git.postgresql.org/pg/commitdiff/601f48076f8036a223f631692db83ec661f785a6

- psql: fix \copy stdin trailing space requirement. Previously a
trailing space was required for \copy ... stdin: copy foo from stdin
; Etsuro Fujita
http://git.postgresql.org/pg/commitdiff/d8a5608d4ac9d4b74772980666cc6626bd18c3ff

- Add comment for VARSIZE_ANY_EXHDR macro. Gurjeet Singh
http://git.postgresql.org/pg/commitdiff/0f59f4a645ec92e580baa4c8feb9f285a8279a15

- docs: Update libpq and testlo examples. Josh Kupershmidt
http://git.postgresql.org/pg/commitdiff/2885006afc81aaabf3a32a873bbed99282f5a978

- fuzzystrmatch: replace broken link in C comment. Laurenz Albe.
http://git.postgresql.org/pg/commitdiff/f0e86930dd56f2da00101d5384cbb51ada3730da

Kevin Grittner pushed:

- Create index on srt table in citext regression tests. Comments and
the tests make clear that the intent is to test with and without an
index, but there was no index.
http://git.postgresql.org/pg/commitdiff/a49d0b75ce41a5480777f0957d5119cb2f393414

Noah Misch pushed:

- Ignore interrupts during quickdie(). Once the administrator has
called for an immediate shutdown or a backend crash has triggered a
reinitialization, no mere SIGINT or SIGTERM should change that
course. Such derailment remains possible when the signal arrives
before quickdie() blocks signals. That being a narrow race
affecting most PostgreSQL signal handlers in some way, leave it for
another patch. Back-patch this to all supported versions.
http://git.postgresql.org/pg/commitdiff/d41cb869aad493178777b6e6e8d1425535349acb

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Peter Geoghegan sent in two revisions of a patch to implement INSERT
... ON DUPLICATE KEY LOCK FOR UPDATE.

Zoltan Boszormenyi sent in another revision of a patch to implement
fetch readahead for ECPG.

Blake Smith sent in another revision of a patch to speed up queries
with hstore using GIN indexes.

Heikki Linnakangas and Stephen Frost traded patches to fix an issue in
libpq's interaction with SSL.

Satoshi Nagayasu sent in two more revisions of a patch to collect a
statistic for WAL buffer dirty writes called
pg_stat_walwriter.dirty_write.

Noah Misch sent in a patch to fix a case where SIGQUIT sent after a
query cancel, the cancel takes precedent and the backend survives.

Bruce Momjian sent in a patch to issue a warning when SET TRANSACTION
is called outside a transaction block.

Ronan Dunklau sent in a patch to implement triggers on foreign tables.

Bruce Momjian sent in a patch to fix some functions in
contrib/unaccent to be immutable.

Fujii Masao sent in another revision of a patch to compress full-page
writes.

Peter Eisentraut sent in a patch to document how to use FOP to build
the PDF documentation.

Samrat Revagade and Sawada Masahiko traded patches to allow fail-back
without taking a fresh backup.

Robert Haas sent in a set of patches to allow terminating background
workers, a way to flag same, and some test code. This may eventually
lead to parallel query.

Peter Eisentraut sent in a patch to remove the maintainer-check
target, roll its functionality into the regular build, and include
Andrew Dunstan's check for duplicate OIDs.

Peter Eisentraut sent in a patch to split off pg_fatal() from pg_log()
in pg_upgrade.

Kevin Grittner sent in a patch to implement a record_identical()
operator as part of the infrastructure for maintaining materialized
views.

MauMau sent in another revision of a patch to make sure shutting down
in immediate mode is reliable.

Andrew (RhodiumToad) Gierth sent in another revision of a patch to
make UNNEST take multiple heterogeneous array arguments and have
TABLE() do similar with multiple SRFs.

Robert Haas and Amit Kapila sent in another revision of a patch to
implment dynamic shared memory.

Dimitri Fontaine sent in a patch to complete the stock PL support for
EVENT TRIGGERS.

Peter Eisentraut sent in another revision of a patch to implement
TRANSFORMS.

Peter Eisentraut sent in a patch to use asprintf() on platforms that
support it.

Atri Sharma and Andrew (RhodiumToad) Gierth traded patches
implementing WITHIN GROUP.

Marko (johto) Tiikkaja sent in a patch to implement a strict mode for
PL/pgsql.

Richard Poole sent in a WIP patch to adds the MAP_HUGETLB flag to
mmap() for shared memory on systems that support it. The patch is
based on Christian Kruse's patch from last year, incorporating
suggestions from Andres Freund.

Marko (johto) Tiikkaja sent in three more revisions of a patch to add
a COMPACT mode for errors where the CONTEXT field is omitted for all
non-error messages.

Marko (johto) Tiikkaja sent in two revisions of a patch to
(optionally) print more information on STRICT failures in PL/PgSQL:

Amit Kapila sent in another revision of a patch to compute the max LSN
of pages.

Peter Eisentraut sent in another revision of a patch to implement
information_schema.parameters.parameter_default.

Andres Freund sent in a patch to allow custom GUCs to be nested more
that one level in config files.

Peter Eisentraut sent in another revision of a patch to revive the
line type.

Bernd Helmle sent in a patch to create a GUC for page checksums.

Alvaro Herrera sent in another revision of a patch to implement
min-max indexes.

Andres Freund sent in a flock of patches intended to help with logical
changesets. Details here:
http://www.postgresql.org/message-id/20130914204913.GA4071@awork2.anarazel.de

Marko (johto) Tiikkaja sent in two revisions of a patch to add
ASSERTions to PL/pgsql.

Abhijit Menon-Sen sent in another revision of a patch to implement
bitmap indexes.

Amit Kapila sent in two more revisions of a patch to fix some
inconsistent behavior in table inheritance.

Satoshi Nagayasu sent in another revision of a patch to update
contrib/pgstattuple.

Alexander Korotkov sent in another revision of a patch to improve GIN
indexes with optional information.

Satoshi Nagayasu sent in another revision of a patch to add CLUSTER
statistics.