== PostgreSQL Weekly News - September 22 2013 ==

== PostgreSQL Weekly News - September 22 2013 ==

Commitfest II of the next cycle is now 1/4 over. With 83 patches, 6
already committed, it's going well so far. 8 patches remain sadly
reviewer-less. Let's fix that this week. If you'd like to help,
write to the pgsql-rrreviewers list (subscription info below), and
we'll help you help us.
http://www.postgresql.org/community/lists/subscribe/

== PostgreSQL Product News ==

HadoopFDW released.
http://www.bigsql.org/se/hadoopfdw/

== PostgreSQL Jobs for September ==

http://archives.postgresql.org/pgsql-jobs/2013-09/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. The CfP deadline is
September 28th, 2013.
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 ==

Heikki Linnakangas pushed:

- Add a GUC to report whether data page checksums are enabled. Bernd
Helmle
http://git.postgresql.org/pg/commitdiff/0892ecbc015930dde2cee9ad464b9b70fdb7667e

Alvaro Herrera pushed:

- Rename various "freeze multixact" variables. It seems to make more
sense to use "cutoff multixact" terminology throughout the backend
code; "freeze" is associated with replacing of an Xid with
FrozenTransactionId, which is not what we do for MultiXactIds.
Andres Freund Some adjustments by Álvaro Herrera
http://git.postgresql.org/pg/commitdiff/dd778e9d888454fdd2c25c66fc268ba9844eb125

- Remove `proc` argument from LockCheckConflicts. This has been
unused since commit 8563ccae2caf. Noted by Antonin Houska
http://git.postgresql.org/pg/commitdiff/1247ea28cbc834bd6750b569537baff4e35edf79

Robert Haas pushed:

- Typo fix. Etsuro Fujita
http://git.postgresql.org/pg/commitdiff/86a174bff0730791c5c262d646d4fe28c2485be1

- Documentation correction. Etsuro Fujita
http://git.postgresql.org/pg/commitdiff/eb3b79ffd4c456b49325df0002dbc4cb6a3741e7

- Fix compiler warning in WaitForBackgroundWorkerStartup(). Per
complaint from Andrew Gierth.
http://git.postgresql.org/pg/commitdiff/496439d943565bdb6cb2eef534cce551c30e8a0f

Fujii Masao pushed:

- Fix typo in comment. Ian Lawrence Barwick
http://git.postgresql.org/pg/commitdiff/6e5f6e59134c4829060321b875e86c538adc0914

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Ronan Dunklau sent in another revision of a patch to add triggers to
foreign tables.

Wang Shuo sent in another revision of a patch to skip rewriting the
table for allowable changes to NUMERIC columns via ALTER TABLE.

Dean Rasheed and Marko (johto) Tiikkaja traded patches to expand the
writeability of VIEWs by determining which can be changed in a sane
way.

Alvaro Herrera and Jaime Casanova traded patches for minmax indexes.

Alvaro Herrera sent in a patch to refactor relscan_details.h out of
relscan.h to reduce unneeded #includes of the same header.

Heikki Linnakangas sent in another revision of an instrumentation
patch to with two functions: one to consume N xids, making it faster
to hit the creation of new XID ranges and wraparound, The other,
print_xidlsnranges(), to print out the contents of the current XID-LSN
range array.

Samrat Revagade and Sawada Masahiko traded patches to make it possible
to fail back without first creating a fresh backup.

Rushabh Lathia sent in another revision of a patch to disallow year
fields of length greater than 4 in all cases.

Hamid Quddus Akhtar sent in a patch to fix a bug in
output/security_label.source where it refers to abs_builddir instead
of libdir.

Marko (johto) Tiikkaja sent in another revision of a patch to
implement a GUC plpgsql.print_strict_params which gives more detail
about parameter problems in PL/pgsql functions when set.

Jeevan Chalke sent in another revision of a patch to create a simple
date constructor for numeric values.

Sameer Thakur and Daniel Farina traded patches to fix some
mis-countings in pg_stat_statements.

Rushabh Lathia, Robert Haas, and Amit Kapila traded patches to fix an
inconsistency in checking for table inheritance.

Andres Freund sent in two more flocks of patches which are inteded to
be infrastructure for logical changeset replication.

Alexander Korotkov sent in two more revisions of a patch to improve
GIN indexing by adding some additional information.

Alexander Korotkov sent in a patch to fix KNN-GiST behaviour with NaN.

Pavel Stehule sent in another revision of a patch to add LOB utility
functions load_lo and make_lo.

Vik Fearing sent in a patch to fix the interaction between
relocatable extensions and pg_dump/pg_restore.

Andres Freund sent in another revision of a patch to allow custom GUCs
to be nested more than one level.

KONDO Mitsumasa sent in a patch to add a Gaussian distribution to
pgbench.

David Rowley sent in three more revisions of a patch to allow
formatting in log_line_prefix.

Robert Haas sent in another revision of a patch to implement dynamic
shared memory.

Mike Blackwell sent in a doc patch to clarify the OPTIONS clause in
contrib/file_fdw.

Alvaro Herrera sent in a patch to handle SSL renegotiation cleanly.

Heikki Linnakangas sent in a patch to detect an issue where freezing
incorrectly releases any predicate locks.

KaiGai Kohei sent in another revision of a patch to implement
row-level access control, this time with a mitigation for a
side-channel attach to which the previous patch was vulnerable.

Vik Fearing sent in another revision of a patch to implement
pg_sleep(interval).

Fabien COELHO sent in a flock of patches improving pgbench progress
reports.

Didier (did447 AT gmail DOT com) sent in a patch to fix a small memory
leak in guc-file.l ParseConfigFile.

Stas Kelvich sent in a patch to add kNN search for cubes with
euclidean, taxicab and Chebyshev distances.