Re: triggers - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: triggers
Date
Msg-id 20050908145927.G86079@megazone.bigpanda.com
Whole thread Raw
In response to triggers  (Kailash Vyas <kailash.vyas@gmail.com>)
List pgsql-admin
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).


pgsql-admin by date:

Previous
From: Guido Barosio
Date:
Subject: Re: triggers
Next
From: Chris Browne
Date:
Subject: Re: triggers