== PostgreSQL Weekly News - December 30 2012 == - Mailing list pgsql-announce

== PostgreSQL Weekly News - December 30 2012 ==

== PostgreSQL Product News ==

dbForge Data Compare for PostgreSQL, a data diff and sync tool for
PostgreSQL that allows users to review all the differences in compared
tables and execute an automatically generated script to remove these
differences, released.
http://www.devart.com/dbforge/postgresql/datacompare/

pgFormatter v1.1, a SQL formatter/beautifier which supports keywords
from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL
keywords are not in the standard, released.
http://sqlformat.darold.net/

PG Jobmon version 1.0.0, an extension for autonomously logging steps
of a function, released.
https://github.com/omniti-labs/pg_jobmon

== PostgreSQL Jobs for December ==

http://archives.postgresql.org/pgsql-jobs/2012-12/threads.php

== PostgreSQL Local ==

The FOSDEM PGDay conference that will be held before FOSDEM in
Brussels, Belgium, on Feb 1st, 2013.  The CfP for both this event and
for the PG track of FOSDEM are open.
http://fosdem2013.pgconf.eu/callforpapers/

PyPgDay will be held on March 13th at the Santa Clara Convention
Center, the first day of PyCon.  Info here:
http://wiki.postgresql.org/wiki/PyPgDay2013
Submit your proposal here by January 20, 2013:
http://tinyurl.com/PyPgDayCfP

PGDay NYC 2013 will be held on March 22, 2013 in New York City.  The
CfP submission deadline is January 7th, 2013 at noon eastern time.
papers AT nycpug DOT org.
http://pgday.nycpug.org/speakers

PostgreSQL Session will be held on March 28th, 2013 in Paris,
France.  The Call for Papers is open.
http://www.postgresql-sessions.org/en/5/

PGCon 2013 will be held May 23-24 2013, in Ottawa at the University of
Ottawa.  The Call for Papers is open.
http://www.pgcon.org/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 david@fetter.org, German language
to pwn@pgug.de, Italian language to pwn@itpug.org.  Spanish language
to pwn@arpug.com.ar.

== Applied Patches ==

Simon Riggs pushed:

- Add function prototype from previous commit.
  http://git.postgresql.org/pg/commitdiff/2dcb2ebee2ec830fbe547459b2176238efc2a3e0

- Fix more weird compiler messages caused by unmatched function
  prototypes.  Andres Freund
  http://git.postgresql.org/pg/commitdiff/42fa810c144cb76c911cc664244bc369911eb840

- Keep rd_newRelfilenodeSubid across overflow.  Teach
  RelationCacheInvalidate() to keep rd_newRelfilenodeSubid across rel
  cache message overflows, so that behaviour is now fully
  deterministic.  Noah Misch
  http://git.postgresql.org/pg/commitdiff/ae9aba69a8608c6e5df01ee4f20c4799f5d2850c

- Update comments on rd_newRelfilenodeSubid.  Ensure comments
  accurately reflect state of code given new understanding, and recent
  changes.  Include example code from Noah Misch to illustrate how
  rd_newRelfilenodeSubid can be reset deterministically.  No code
  changes.
  http://git.postgresql.org/pg/commitdiff/c2b32180649fe9105e784ad0519fe243605f78a3

Tom Lane pushed:

- Fix some minor issues in view pretty-printing.  Code review for
  commit 2f582f76b1945929ff07116cd4639747ce9bb8a1: don't use a static
  variable for what ought to be a deparse_context field, fix
  non-multibyte-safe test for spaces, avoid useless and potentially
  O(N^2) (though admittedly with a very small constant) calculations
  of wrap positions when we aren't going to wrap.
  http://git.postgresql.org/pg/commitdiff/3f88b080030682adf359248c9cb7f8b2068a539e

Bruce Momjian pushed:

- Add pg_upgrade --jobs parameter.  Add pg_upgrade --jobs, which
  allows parallel dump/restore of databases, which improves
  performance.
  http://git.postgresql.org/pg/commitdiff/6f1b9e4efd94fc644f5de5377829d42e48c3c758

Peter Eisentraut pushed:

- doc: Replace "NOTE" with proper markup
  http://git.postgresql.org/pg/commitdiff/925ce77c0359eff9310f7954294f257dafb0c2db

- doc: Correct description of LDAP authentication.  Parts of the
  description had claimed incorrect pg_hba.conf option names for LDAP
  authentication.  Laurenz Albe.
  http://git.postgresql.org/pg/commitdiff/103cc89362accb04cf37a9063e51eac04d489e89

- Fix compiler warning about uninitialized variable
  http://git.postgresql.org/pg/commitdiff/0e690209eec61f8b70c57f8feeab0a3cd853103b

- doc: Correct description of ldapurl.  The ldapurl option doesn't
  actually support specifying a user name and password.  Laurenz Albe.
  http://git.postgresql.org/pg/commitdiff/7eb559a86d773e0105ae5823e0c776c3af3c3fe2

Alvaro Herrera pushed:

- Remove unused NextLogPage macro.  Commit 061e7efb1b did away with
  its last caller, but neglected to remove the actual definition.
  Author: Andres Freund
  http://git.postgresql.org/pg/commitdiff/eaa1f7220ae83997b56adcae1fbb7b2e92bfc050

- Assign InvalidXLogRecPtr instead of MemSet(0) For consistency.
  Author: Andres Freund
  http://git.postgresql.org/pg/commitdiff/24eca7977ed208de33791af8890975ffcf086598

- Remove obsolete XLogRecPtr macros.  This gets rid of XLByteLT,
  XLByteLE, XLByteEQ and XLByteAdvance.  These were useful for brevity
  when XLogRecPtrs were split in xlogid/xrecoff; but now that they are
  simple uint64's, they are just clutter.  The only downside to making
  this change would be ease of backporting patches, but that has been
  negated by other substantive changes to the involved code anyway.
  The clarity of simpler expressions makes the change worthwhile.
  Most of the changes are mechanical, but in a couple of places, the
  patch author chose to invert the operator sense, making the code
  flow more logical (and more in line with preceding comments).
  Author: Andres Freund Eyeballed by Dimitri Fontaine and Alvaro
  Herrera
  http://git.postgresql.org/pg/commitdiff/5ab3af46ddd2f2c2b248f1ffdb688b394d4bb387

Robert Haas pushed:

- Adjust more backend functions to return OID rather than void.  This
  is again intended to support extensions to the event trigger
  functionality.  This may go a bit further than we need for that
  purpose, but there's some value in being consistent, and the OID may
  be useful for other purposes also.  Dimitri Fontaine
  http://git.postgresql.org/pg/commitdiff/82b1b213cad3a69cf5f3dfaa81687c14366960fc

Heikki Linnakangas pushed:

- Keep timeline history files restored from archive in pg_xlog.  The
  cascading standby patch in 9.2 changed the way WAL files are treated
  when restored from the archive.  Before, they were restored under a
  temporary filename, and not kept in pg_xlog, but after the patch,
  they were copied under pg_xlog.  This is necessary for a cascading
  standby to find them, but it also means that if the archive goes
  offline and a standby is restarted, it can recover back to where it
  was using the files in pg_xlog.  It also means that if you take an
  offline backup from a standby server, it includes all the required
  WAL files in pg_xlog.  However, the same change was not made to
  timeline history files, so if the WAL segment containing the
  checkpoint record contains a timeline switch, you will still get an
  error if you try to restart recovery without the archive, or recover
  from an offline backup taken from the standby.  With this patch,
  timeline history files restored from archive are copied into pg_xlog
  like WAL files are, so that pg_xlog contains all the files required
  to recover.  This is a corner-case pre-existing issue in 9.2, but
  even more important in master where it's possible for a standby to
  follow a timeline switch through streaming replication.  To make
  that possible, the timeline history files must be present in
  pg_xlog.
  http://git.postgresql.org/pg/commitdiff/60df192aea0e6458f20301546e11f7673c102101

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==

Dimitri Fontaine sent in four more revisions of a patch to add EVENT
triggers.

Pavel Stehule sent in a patch to add a regrole type.

Andrew Dunstan sent in another WIP patch for the JSON API.

Peter Bex sent in a patch intended to improve password hashing by
adding bcrypt.

Alvaro Herrera and Heikki Linnakangas traded patches to fix bgworkers
in the EXEC_BACKEND case.

Kyotaro HORIGUCHI sent in two more revisions of a patch to reduce the
amount of WAL generated during update operations.

Alvaro Herrera sent in another revision of a patch to implement
foreign key locks.

Heikki Linnakangas sent in a patch to fix a performance regression in
dynamic SQL by eliminating some unneeded copying of the parse- and
plan trees.

Pavel Stehule sent in a patch to implement SQL:2011 named parameters.

Dan Farina sent in four revisions of a patch to establish a maximum
under-estimate of the number of calls for a given pg_stat_statements
entry.  That means the number of calls to the canonical form of the
query is between 'calls' and 'calls + calls_underest'.

Pavel Stehule sent in another revision of a patch to enhance error
fields in PL/pgsql.

Tom Lane sent in a patch to make view dump/restore safe at the
column-alias level.

Craig Ringer sent in a patch to change the Windows build docs to point
to flex and bison from msys.