--- ashok raj <ashokexplorer(at)gmail(dot)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
Richard Broersma Jr.
In response to
pgsql-sql by date
|Next:||From: Jon Horsman||Date: 2007-08-20 15:47:12|
|Subject: Re: When is a shared library unloaded?|
|Previous:||From: ashok raj||Date: 2007-08-20 04:56:46|
|Subject: TRIGGERS and FUNCTIONS|