== PostgreSQL Weekly News - May 31 2009 ==

== PostgreSQL Weekly News - May 31 2009 ==

== PostgreSQL Product News ==

Version 1.9 of Sonar, an Open Source code quality management platform,
now supports PostgreSQL.
http://sonar.codehaus.org/

== PostgreSQL 8.4 Feature of the Week ==

array_agg(): SQL standard way to aggregate values into an array.  Now
it's official ... and faster, too.

== PostgreSQL Tip of the Week ==

If your aggregate queries are being slow, try increasing work_mem.

== PostgreSQL Jobs for June ==

http://archives.postgresql.org/pgsql-jobs/2009-06/threads.php

== PostgreSQL Local ==

PGDay Junin / Buenos Aires Unnoba will be on June 6, 2009.
http://www.arpug.com.ar/trac/wiki/PgDayUnnoba

The PostgreSQL/PostGIS community will be meeting in Zurich on June 6,
2009.  Details (de_CH) below:
http://gis.hsr.ch/wiki/PostgreSQL-PostGIS-Höck

Save The Date: pgDay San Jose.  Sunday, July 19th 2009 immediately
before OSCON.  CfP, more info TBA!

PGCon Brazil will be take place October 23-24 2009 at Unicamp in
Campinas, Sao Paulo state.

PGDay.EU 2009 will be at Telecom ParisTech in Paris, France on
November 6-7, 2009.
http://www.pgday.eu/

JPUG 10th Anniversary Conference has started its Request for
Proposals.  The conference is November 20-21, 2009 in Tokyo, Japan.
http://archives.postgresql.org/pgsql-announce/2009-05/msg00018.php

== PostgreSQL in the News ==

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

PostgreSQL Weekly News is brought to you this week by David Fetter,
Josh Berkus and Guillaume Smet.

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.

== Applied Patches ==

Tom Lane committed:

- Add range checks to time_recv() and timetz_recv(), to prevent binary
   input of time values that would not be accepted via textual input.
   Per gripe from Andrew McNamara.  This is potentially a
   back-patchable bug fix, but for the moment it doesn't seem
   sufficiently high impact to justify doing that.

- Remove unused declarations of EncodeTimeOnly and DecodeTimeOnly.

- Allow the second argument of pg_get_expr() to be just zero when
   deparsing an expression that's not supposed to contain variables.
   Per discussion with Gevik Babakhani, this eliminates the need for an
   ugly kluge (namely, specifying some unrelated relation name).
   Remove one such kluge from pg_dump.

- Remove the useless and rather inconsistent return values of
   EncodeDateOnly, EncodeTimeOnly, EncodeDateTime, EncodeInterval.
   These don't have any good reason to fail, and their callers were
   mostly not checking anyway.

- Improve documentation about function volatility: mention the
   snapshot visibility effects in a couple of places where people are
   likely to look for it.  Per discussion of recent question from Karl
   Nack.

- Ignore RECHECK in CREATE OPERATOR CLASS, just throwing a NOTICE,
   instead of throwing an error as 8.4 had been doing.  The error
   interfered with porting old database definitions (particularly for
   pg_migrator) without really buying any safety.  Per bug #4817 and
   subsequent discussion.

- In pgsql/doc/src/sgml/release-8.4.sgml, improve release note
   explanation of the change in libpq's handling of default usernames
   versus Kerberos tickets.  Per confusion about what bug #4824 was
   really about.

- In pgsql/src/backend/catalog/index.c, update obsolete comment in
   index_drop().  When the comment was written, queries frequently took
   no lock at all on individual indexes.  That's not true any more, but
   we still need lock on the parent table to make it safe to use cached
   lists of index OIDs.

Bruce Momjian committed:

- In pgsql/doc/src/sgml/backup.sgml, remove tabs from SGML file.

- In pgsql/doc/src/sgml/libpq.sgml, document that forking while having
   open libpq connections is not advised.

Michael Meskes committed:

- In pgsql/src/interfaces/libpq/fe-exec.c, reverting patch just in
   case a compiler treats this enum as signed.

- Change macros to make gcc quiet when parsing.

Peter Eisentraut committed:

- Fix compiler warnings on Sun Studio of the sort '"tsquery_op.c",
   line 193: warning: syntax error: empty declaration.'  Zdenek Kotala.

- Fix to use the same format specifiers in both branches of a
   ngettext().  Zdenek Kotala.

Magnus Hagander committed:

- In pgsql/src/backend/libpq/auth.c, properly return the usermap
   result when doing gssapi authentication.  Without this, the username
   was in practice never matched against the kerberos principal used to
   log in.

Heikki Linnakangas committed:

- In pgsql/src/backend/access/transam/xlog.c, when archiving is
   enabled, rotate the last WAL segment at shutdown so that all
   transactions are archived.  Original patch by Guillaume Smet.

== Rejected Patches (for now) ==

No one was disappointed this week :-)

== Pending Patches ==