On 20th of July, Robert Haas committed patch: Make new event trigger facility actually do something. Commit 3855968f328918b6cd1401dd11d109d471a54d40 added syntax, pg_dump, psql support, and documentation, but the triggers didn't actually fire. With this commit, they now do. This is still a pretty basic ...

On 23th of January, Simon Riggs committed patch: ALTER [IF EXISTS] ... allows silent DDL if required, e.g. ALTER FOREIGN TABLE IF EXISTS foo RENAME TO bar Pavel Stehule

On 25th Robert Haas committed patch which adds first of 'CREATE IF NOT EXISTS' commands: Log Message: ----------- CREATE TABLE IF NOT EXISTS. Reviewed by Bernd Helmle.

July 22nd, 2009 by depesz | Tags: , , , , , , , , | Comments Off on Waiting for 8.5 – pgsql: DROP IF EXISTS for columns and constraints.

On 205h of July Andrew Dunstan committed patch by Andres Freund : Log Message: ----------- DROP IF EXISTS for columns and constraints. Andres Freund.

June 18th, 2008 by depesz | Tags: , , , , , | 7 comments »

Every now and then I see people ask the question - how to create table if it doesn't exist yet, how to drop it, but only if it does exist and so on. Well, starting from 8.2 dropping should be not ...