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@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828
<<attachment: smime.p7s>>
