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 02:04:22
Message-ID: (view raw or whole 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.


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
> 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
PostgreSQL General Bits    http:/
   "Left foot, right foot, left foot, breathe. 
   Right foot, left foot, right foot, breathe." --Father Tom

In response to

sfpug by date

Next:From: Josh BerkusDate: 2003-05-20 16:13:00
Subject: Re: DDL triggers?
Previous:From: David FetterDate: 2003-05-20 01:56:59
Subject: Re: DDL triggers?

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