On Thu, 8 Sep 2005, Kailash Vyas wrote: > hi > > I have a query regarding triggers. > On INSERT, UPDATE, DELETE I want to fire a trigger to relect it to another > database on postgres sever. > how can I do this operation. This is tricky, because you probably want to have the same transactional occurances as well (ie, rollbacks not leaving the rolledback data on the other database). You might be best off looking at some of the replication systems for PostgreSQL to see what they do (or perhaps just using one).
