Re: TRIGGERS and FUNCTIONS

--- 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.