Skip site navigation (1) Skip section navigation (2)

Re: TRIGGERS and FUNCTIONS

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: ashok raj <ashokexplorer(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: TRIGGERS and FUNCTIONS
Date: 2007-08-20 11:21:06
Message-ID: 535186.34449.qm@web31810.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-sql
--- 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
production systems.

http://pgfoundry.org/projects/slony1/

Regards,
Richard Broersma Jr.

In response to

pgsql-sql by date

Next:From: Jon HorsmanDate: 2007-08-20 15:47:12
Subject: Re: When is a shared library unloaded?
Previous:From: ashok rajDate: 2007-08-20 04:56:46
Subject: TRIGGERS and FUNCTIONS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group