Re: Create user trigger? - Mailing list pgsql-general

From Decibel!
Subject Re: Create user trigger?
Date
Msg-id B1B9AC05-4481-4D65-8941-CE023AC2FDE3@decibel.org
Whole thread Raw
In response to Create user trigger?  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: Create user trigger?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Dropping the slony list.

On Mar 18, 2008, at 5:32 AM, Glyn Astill wrote:
> We're setting up 3 servers replicating using slony. I was wondering
> if it'd be possible for me to create a set of triggers that fire
> whenever a user is created/dropped/modified on one of the servers
> that goes and performs the same action the other two servers.

There is no support for DDL triggers, even though it's frequently
requested. Unfortunately, almost every time it's brought up it
degrades into a debate about why we can't add triggers to catalog
tables; forgetting that there's other ways to do this. Searching the
pgsql-hackers archives should be enlightening.
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: return value from SQL statement
Next
From: Decibel!
Date:
Subject: Re: Feature request/suggestion - CREATE SCHEMA LIKE