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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2003-05-20 18:38:43 | Re: valid timezone abbreviations/displaying timezone value? |
Previous Message | Stephan Szabo | 2003-05-20 17:52:03 | Re: DDL triggers? |