April 23rd, 2015 by depesz | Tags: , , , , , , , , , | Comments Off on Waiting for 9.5 – Reduce lock levels of some trigger DDL and add FKs

On 5th of April, Simon Riggs committed patch: Reduce lock levels of some trigger DDL and add FKs Reduce lock levels to ShareRowExclusive for the following SQL CREATE TRIGGER (but not DROP or ALTER) ALTER TABLE ENABLE TRIGGER ALTER TABLE DISABLE TRIGGER ...

December 19th, 2013 by depesz | Tags: , , , , | Comments Off on Waiting for 9.4 – Improve EXPLAIN to print the grouping columns in Agg and Group nodes.

On 12th of December, Tom Lane committed patch: Improve EXPLAIN to print the grouping columns in Agg and Group nodes. Per request from Kevin Grittner.

June 30th, 2013 by depesz | Tags: , , , , , , , , , | Comments Off on Waiting for 9.4 – ALTER TABLE … ALTER CONSTRAINT for FKs

On 28th of June, Simon Riggs committed patch: ALTER TABLE ... ALTER CONSTRAINT for FKs Allow constraint attributes to be altered, so the default setting of NOT DEFERRABLE can be altered to DEFERRABLE and back. Review by Abhijit Menon-Sen