Posts Tagged ‘sql’

Conditional DDL?

2008-06-18 14:53:23 CEST | 5 Comments | Tags: , , , , ,

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 a problem anymore. But what about create? Alter?

Let’s try to do it…

- MORE -

waiting for 8.4

2008-03-28 22:56:43 CET | 4 Comments | Tags: , , , , , , ,

another new, cool feature commited by tom lane: “Support statement-level ON TRUNCATE triggers.”

original patch was submitted by simon riggs, and tom commited it today/yesterday (depending on time zone).

- MORE -