DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=2+e6c+wzcWZr86YLf/0pBICkj/nyOw6Tf7igbxj31glE9L8A8GWlu5IfAjC8gSz/ZUiGD2kfO8kGHFVZjmDHSDLHjSacKjvOEifw2Eqx3/uZFoXN/KdppeWVoyixfw3MHkZKXYU23TfSZH1M/2fb1Pu00yW86F2gzAVRJ5hC8Xk=;
Date: Mon, 20 Aug 2007 04:21:06 -0700 (PDT)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: TRIGGERS and FUNCTIONS
To: ashok raj <ashokexplorer@gmail.com>, pgsql-sql@postgresql.org
In-Reply-To: <399c75c20708192156i62567ce7obf933be20fed7ff@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <535186.34449.qm@web31810.mail.mud.yahoo.com>


--- ashok raj <ashokexplorer@gmail.com> wrote:

>  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

You probably can get the statement.  However, your solution sounds a lot like an existing
replication solution, "Slony".  It will do exactly what you want, and is already stable for
production systems.

http://pgfoundry.org/projects/slony1/

Regards,
Richard Broersma Jr.