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 0D265D8AE4 for ; Thu, 8 Sep 2005 18:29:50 -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 31120-09 for ; Thu, 8 Sep 2005 21:29:44 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.193]) by svr1.postgresql.org (Postfix) with ESMTP id 94353D8AB2 for ; Thu, 8 Sep 2005 18:29:44 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id c2so317693nfe for ; Thu, 08 Sep 2005 14:29:46 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=B0o2C7jpciBn0np8T+SGGIFY9B3RJ5Ee8KR54+mNVdooOL1SGCbVAXsA8Rt2R7fmFxXLw3Sr4t8SGz0DO1gAEAscJPBTIbZFy4iFXSLC8vs4EITNz5BsKLUK5SWTZInHop8DTvZF25CZFIIH5P5HNWPTJ18HwbgEI9uBL1nuIeM= Received: by 10.48.250.3 with SMTP id x3mr244249nfh; Thu, 08 Sep 2005 14:29:46 -0700 (PDT) Received: by 10.48.250.10 with HTTP; Thu, 8 Sep 2005 14:29:46 -0700 (PDT) Message-ID: Date: Thu, 8 Sep 2005 22:29:46 +0100 From: Guido Barosio Reply-To: gbarosio@gmail.com To: Kailash Vyas Subject: Re: triggers Cc: pgsql-admin@postgresql.org In-Reply-To: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_23483_6544398.1126214986294" References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.183 required=5 tests=[AWL=0.063, HTML_50_60=0.095, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200509/89 X-Sequence-Number: 18826 ------=_Part_23483_6544398.1126214986294 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline http://www.google.co.uk/search?hl=3Den&q=3DTRIGGER+%2B+postgresql+%2B+8&met= a=3D which actually will guide you to: http://www.postgresql.org/docs/current/static/sql-createtrigger.html ..that actually is the pgsql man. rtfm :) Best wishes, Guido On 9/8/05, Kailash Vyas wrote:=20 >=20 > hi >=20 > I have a query regarding triggers. > On INSERT, UPDATE, DELETE I want to fire a trigger to relect it to anothe= r=20 > database on postgres sever. > how can I do this operation. >=20 > Thanks in advance, > Kailash Vyas >=20 >=20 --=20 "Adopting the position that you are smarter than an automatic optimization algorithm is generally a good way to achieve less performance, not more" - Tom Lane. ------=_Part_23483_6544398.1126214986294 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
which actually will guide you to:
 
 
..that actually is the pgsql man.
 
rtfm :)
 
Best wishes,
Guido

 
On 9/8/05, K= ailash Vyas <kailash.vyas@= gmail.com> wrote:
hi

I have a query regardi= ng triggers.
On INSERT, UPDATE, DELETE I want to fire a trigger to relec= t it to another database on postgres sever.
how can I do this operation.

Thanks in advance,
Kailash Vyas




--
"Adopting the position that you are smarter than an automa= tic
optimization algorithm is generally a good way to achieve less
perfo= rmance, not more" - Tom Lane.=20 ------=_Part_23483_6544398.1126214986294--