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 01:56:59
Message-ID: 20030520015659.GA16543@fetter.org (view raw or flat)
Thread:
Lists: sfpug
On Mon, May 19, 2003 at 06:16:25PM -0700, Sean Chittenden wrote:
> > Is there some way to fire triggers on DDL's?
> 
> Sure, set a trigger for one of the system catalog tables.  If you
> use pg_class, make sure you're checking for the type's.  :)  -sc

That is *brilliant* :)

Thanks!

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: eleinDate: 2003-05-20 02:04:22
Subject: Re: DDL triggers?
Previous:From: David FetterDate: 2003-05-19 23:54:17
Subject: DDL triggers?

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