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