Skip site navigation (1) Skip section navigation (2)

Re: DDL triggers?

From: David Fetter <david(at)fetter(dot)org>
To: SF Postgres <sfpug(at)postgresql(dot)org>
Subject: Re: DDL triggers?
Date: 2003-05-20 16:33:34
Message-ID: 20030520163333.GC18825@fetter.org (view raw or flat)
Thread:
Lists: sfpug
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

In response to

Responses

sfpug by date

Next:From: Josh BerkusDate: 2003-05-20 16:46:02
Subject: Re: DDL triggers?
Previous:From: Josh BerkusDate: 2003-05-20 16:13:00
Subject: Re: DDL triggers?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group