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 02:04:22 |
Message-ID: | 200305191904.22105.elein@varlena.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | sfpug |
Not specifically triggers. However, you could disable
access to DDL calls and wrap them in functions with permissions
which perform the DDL and the extra bit which would have
gone into the trigger function. Some DDL may not be allowed
in functions, but I cannot recall what.
Adding the triggers on the pg_catalog table wouldn't
help because the backend sometimes uses the backdoor
to update them.
--elein
On Monday 19 May 2003 16:54, David Fetter wrote:
> Kind people,
>
> Is there some way to fire triggers on DDL's?
>
> Big TIA for any pointers on this :)
>
> 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 1: subscribe and unsubscribe commands go 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 | Josh Berkus | 2003-05-20 16:13:00 | Re: DDL triggers? |
Previous Message | David Fetter | 2003-05-20 01:56:59 | Re: DDL triggers? |