| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Kailash Vyas <kailash(dot)vyas(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: triggers |
| Date: | 2005-09-08 22:01:23 |
| Message-ID: | 20050908145927.G86079@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Browne | 2005-09-08 22:29:01 | Re: triggers |
| Previous Message | Guido Barosio | 2005-09-08 21:29:46 | Re: triggers |