On 18th of December Bruce Momjian committed very important, but relatively small, patch: Log Message: ----------- Install server-side language PL/pgSQL by default. There is no point in showing it, commit log tells all - basically from 8.5 on PL/pgSQL will be enabled by default ...
On 15th of December Tom Lane committed patch by Andrew Gierth (aka RhodiumToad), which adds interesting capability: Log Message: ----------- Support ORDER BY within aggregate function calls, at long last providing a non-kluge method for controlling the order in which values are fed to ...
Today small, but (at least for me) really useful patch. Committed on 15th of December by Robert Haas, and written by Itagaki Takahiro, this patch does: Log Message: ----------- Add an EXPLAIN (BUFFERS) option to show buffer-usage statistics. This patch also removes buffer-usage statistics ...
On 7th of December, Tom Lane committed patch by Jeff Davis that adds general exclusion constraints: Log Message: ----------- Add exclusion constraints, which generalize the concept of uniqueness to support any indexable commutative operator, not just equality. Two rows violate the exclusion constraint if ...
Just recently I wrote about DO command in PostgreSQL 8.5, and now (since 29th of November) we have DO with PL/Perl support. Written by Joshua Tolley and committed by Tom Lane, the patch: Log Message: ----------- Add support for anonymous code blocks (DO blocks) ...
On 28th of November Tom Lane committed patch by Dave Page, which adds new capability to system monitoring and logging: Log Message: ----------- Add support for an application_name parameter, which is displayed in pg_stat_activity and recorded in log entries. Dave Page, reviewed by Andres Freund
On 22nd of November Tom Lane committed patch by Roger Leigh which fixes my pet peeve: Log Message: ----------- Improve psql's tabular display of wrapped-around data by inserting markers in the formerly-always-blank columns just to left and right of the data. Different marking is used ...
On 20th of November Tom Lane committed patch by Takahiro Itagaki which adds interesting functionality: Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be checked to determine whether the trigger should be fired. For BEFORE triggers this is mostly ...
On 18th of November Tom Lane committed patch by Laurenz Albe which adds very interesting capability: Add a hook to CREATE/ALTER ROLE to allow an external module to check the strength of database passwords, and create a sample implementation of such a hook ...
On 13th of November (I know, backlog again), Tom Lane committed patch which make PostgreSQL more strict about what happens in stored procedures in PL/pgSQL: Add control knobs for plpgsql's variable resolution behavior, and make the default be "throw error on conflict", ...
