From: Richard Broersma Jr <rabroersma@yahoo.com>
To: ashok raj <ashokexplorer@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: TRIGGERS and FUNCTIONS
Date: Mon, 20 Aug 2007 04:21:06 -0700 (PDT)
Message-ID: <535186.34449.qm@web31810.mail.mud.yahoo.com> (raw)
In-Reply-To: <399c75c20708192156i62567ce7obf933be20fed7ff@mail.gmail.com>
--- 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rabroersma@yahoo.com, ashokexplorer@gmail.com
Subject: Re: TRIGGERS and FUNCTIONS
In-Reply-To: <535186.34449.qm@web31810.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox