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: 200305191904.22105.elein@varlena.com (view raw or flat)
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


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-2014 The PostgreSQL Global Development Group