Thread: TRIGGERS and FUNCTIONS

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

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