Re: Create user trigger?

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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828