On 28th of July, Simon Riggs committed patch which:
Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.
Avoid hard-coding lockmode used for many altering DDL commands, allowing easier
future changes of lock levels. Implementation of initial analysis on DDL
sub-commands, so that many lock levels are now at ShareUpdateExclusiveLock or
ShareRowExclusiveLock, allowing certain DDL not to block reads/writes.
First of number of planned changes in this area; additional docs required
when full project complete.
Continue reading Waiting for 9.1 – Reduced lock levels for ALTER TABLE
On 25th Robert Haas committed patch which adds first of ‘CREATE IF NOT EXISTS' commands:
CREATE TABLE IF NOT EXISTS.
Reviewed by Bernd Helmle.
Continue reading Waiting for 9.1 – CREATE TABLE IF NOT EXISTS
On 20th of July, Robert Haas committed (and later committed change to it) patch which adds another \* command to psql:
Add \conninfo command to psql, to show current connection info.
David Christensen. Reviewed by Steve Singer. Some further changes by me.
Continue reading Waiting for 9.1 – \conninfo in psql
Generally I write about new features, but this change is relatively important.
Yesterday, on 20th of July, Robert Haas committed following change:
Change the default value of standard_conforming_strings to on.
This change should be publicized to driver maintainers at once and
release-noted as an incompatibility with previous releases.
Continue reading Waiting for 9.1 – standard_conforming_strings = on
Relatively soon we will have 9.0, and we will move with development to 9.1 (we as in: PostgreSQL community, I don't know C so I can't help developing myself, but I will at least try to keep up with changes in the ‘Waiting for' series).
Continue reading Dream wishlist for 9.1