Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id F216D9F9DBB
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 20 Aug 2007 01:56:50 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024)
	with ESMTP id 50959-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Mon, 20 Aug 2007 01:56:46 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.183])
	by postgresql.org (Postfix) with ESMTP id 8C2559F983F
	for <pgsql-sql@postgresql.org>; Mon, 20 Aug 2007 01:56:47 -0300 (ADT)
Received: by wa-out-1112.google.com with SMTP id v27so630090wah
	for <pgsql-sql@postgresql.org>; Sun, 19 Aug 2007 21:56:46 -0700 (PDT)
DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	b=ifBqIFXmKTiprd35zOp4ta78d/jpkscKgWVT0PI+AYLbmHEGjCVpqKGwesKnu26iolKk9JpwAyj6bseBgZ51z36vbX4YyJucNaDFN+yFc37sn9uH4CaZL6LuXtkGR8tKQHl5j3UzuCGaLsJtXN8tGoPb1zeJ30QuoOCmU0H9GxY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=oLwMAPFo2BApwU/URoSU9IAm3T2gNTDg2cyV+bTYY1e2Fk9Sv+nvv8eDeHXUPfSBQJldRS2yfIheIUIOeTZV/HMnDEZORQY5Beq/NRJIxTT0Jv/EcI+luB8tyE1K1EEIluBdQB+QoZFOWlS9YYrRciC7qMCQeBwIoaw0Jw3gazk=
Received: by 10.114.59.1 with SMTP id h1mr2139063waa.1187585806457;
	Sun, 19 Aug 2007 21:56:46 -0700 (PDT)
Received: by 10.114.61.8 with HTTP; Sun, 19 Aug 2007 21:56:46 -0700 (PDT)
Message-ID: <399c75c20708192156i62567ce7obf933be20fed7ff@mail.gmail.com>
Date: Mon, 20 Aug 2007 10:26:46 +0530
From: "ashok raj" <ashokexplorer@gmail.com>
To: pgsql-sql@postgresql.org
Subject: TRIGGERS and FUNCTIONS
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_133066_30040970.1187585806439"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200708/156
X-Sequence-Number: 29094

------=_Part_133066_30040970.1187585806439
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

 Hello All ,

               I am having a table named  "test"  with a trigger  " tri_test
"  which triggers the function  " replicate() "  on insert, update  and
delete .
               Can I able to get the  SQL STATEMENT  which triggers the
function replicate ( ) ,  inside the function definition replicate ( ) .
               So that I could execute that statement in the remote
postgreSQL server

Please help
ashok

------=_Part_133066_30040970.1187585806439
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

&nbsp;Hello All , <br><br>&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I am having a table named&nbsp; &quot;test&quot;&nbsp; with a trigger&nbsp; &quot; tri_test &quot;&nbsp; which triggers the function&nbsp; &quot; replicate() &quot;&nbsp; on insert, update&nbsp; and delete .&nbsp; <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Can I able to get the&nbsp; SQL STATEMENT&nbsp; which triggers the function replicate ( ) ,&nbsp; inside the function definition replicate ( ) .
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; So that I could execute that statement in the remote postgreSQL server <br><br>Please help <br>ashok &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  <br>

------=_Part_133066_30040970.1187585806439--