June 12th, 2011 by depesz | Tags: , | 4 comments »

And so, it happened. After todays refresh of my Pg, I got: $ select version(); ...

On 6th of March, Simon Riggs committed patch: Efficient transaction-controlled synchronous replication. If a standby is broadcasting reply messages and we have named one or more standbys in synchronous_standby_names then allow users who set synchronous_replication to wait for commit, which then provides strict data integrity ...

On 25th of February, Tom Lane committed patch: Support data-modifying commands (INSERT/UPDATE/DELETE) in WITH.   This patch implements data-modifying WITH queries according to the semantics that the updates all happen ...

Well, saying that on particular date someone committed patch, wouldn't be really telling. In fact various bits and pieces of underlying logic have been committed for a long time, but now we finally have some functionality visible and available to ...

On 18th of February, Itagaki Takahiro committed patch: Add transaction-level advisory locks.   They share the same locking namespace with the existing session-level advisory locks, but they are automatically released at the end of the current transaction and cannot be released explicitly via unlock functions.   Marko Tiikkaja, ...

On 18th of February, Alvaro Herrera committed patch: Convert Postgres arrays to Perl arrays on PL/perl input arguments   More generally, arrays are turned in Perl array references, and row and composite types are turned into Perl hash references. This is done recursively, in ...

On 16th of February, Tom Lane committed patch: Add FOREACH IN ARRAY looping to plpgsql.   (I'm not entirely sure that we've finished bikeshedding the syntax details, but the functionality seems OK.)   Pavel Stehule, reviewed by Stephen Frost and Tom Lane

On 12th of February, Robert Haas committed patch: Teach ALTER TABLE .. SET DATA TYPE to avoid some table rewrites.   When the old type is binary coercible to the new type and the using clause does not change ...

On 16th of February, , Robert Haas committed patch: pg_ctl promote   Fujii Masao, reviewed by Robert Haas, Stephen Frost, and Magnus Hagander.

On 8th of February, Peter Eisentraut committed patch: Per-column collation support   This adds collation support for columns and domains, a COLLATE clause to override it per expression, and B-tree index support.   Peter Eisentraut reviewed by Pavel Stehule, Itagaki Takahiro, Robert Haas, Noah Misch   Branch ------ master