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

Re: DDL triggers?

From: elein <elein(at)varlena(dot)com>
To: David Fetter <david(at)fetter(dot)org>,SF Postgres <sfpug(at)postgresql(dot)org>
Cc: elein(at)varlena(dot)com
Subject: Re: DDL triggers?
Date: 2003-05-20 18:36:11
Message-ID: 200305201136.11562.elein@varlena.com (view raw or flat)
Thread:
Lists: sfpug
I don't think this will work as I've said before
because some of the system catalog tables are
updated through the backdoor, not via SQL so
the triggers would not necessarily be fired.

The parsing out of the log does seem a better
idea than the wrappers I was suggesting, though.

elein


On Monday 19 May 2003 18:56, David Fetter wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
> 
> 

-- 
=============================================================
elein(at)varlena(dot)com     Database Consulting     www.varlena.com
PostgreSQL General Bits    http:/www.varlena.com/GeneralBits/
   "Left foot, right foot, left foot, breathe. 
   Right foot, left foot, right foot, breathe." --Father Tom


In response to

sfpug by date

Next:From: eleinDate: 2003-05-20 18:38:43
Subject: Re: valid timezone abbreviations/displaying timezone value?
Previous:From: Stephan SzaboDate: 2003-05-20 17:52:03
Subject: Re: DDL triggers?

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