--- ashok raj <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
