Re: Create user trigger?

Decibel! wrote:
> 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.

We have a potential patch for 8.4 for this.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +