X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CC428D8A93 for ; Thu, 8 Sep 2005 19:01:25 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 40434-03 for ; Thu, 8 Sep 2005 22:01:22 +0000 (GMT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 35650D89E0 for ; Thu, 8 Sep 2005 19:01:21 -0300 (ADT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id A81B035388; Thu, 8 Sep 2005 15:01:23 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A686335384; Thu, 8 Sep 2005 15:01:23 -0700 (PDT) Date: Thu, 8 Sep 2005 15:01:23 -0700 (PDT) From: Stephan Szabo To: Kailash Vyas Cc: pgsql-admin@postgresql.org Subject: Re: triggers In-Reply-To: Message-ID: <20050908145927.G86079@megazone.bigpanda.com> References: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200509/90 X-Sequence-Number: 18827 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).