Re: DDL triggers?

On Tue, May 20, 2003 at 09:13:00AM -0700, Josh Berkus wrote:
> David,

> > Is there some way to fire triggers on DDL's?

> Not easily, no.

> Why don't you describe the whole problem? There may be a simple
> solution to what you want to do.

Roight. In a more perfect world, people would do their DDL changes
in some slightly more trackable way than the psql command line.
Unfortunately, people sometimes don't. What I'd like to do is make it
so that tables, views, functions, &c have comments stuck on (inserted
or appended, as appropriate) automagically. These comments would be
the DDL statement that did the deed. I'm not so worried about DDL
statements like DROP, but CREATE and ALTER would be very, very nice to
be able to track.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778