pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedTRIGGERS and FUNCTIONS
2+ messages / 2 participants
[nested] [flat]
* TRIGGERS and FUNCTIONS
@ 2007-08-20 04:56 ashok raj <ashokexplorer@gmail.com>
2007-08-20 11:21 ` Re: TRIGGERS and FUNCTIONS Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: ashok raj @ 2007-08-20 04:56 UTC (permalink / raw)
To: pgsql-sql
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
Please help
ashok
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: TRIGGERS and FUNCTIONS
2007-08-20 04:56 TRIGGERS and FUNCTIONS ashok raj <ashokexplorer@gmail.com>
@ 2007-08-20 11:21 ` Richard Broersma Jr <rabroersma@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Broersma Jr @ 2007-08-20 11:21 UTC (permalink / raw)
To: ashok raj <ashokexplorer@gmail.com>; pgsql-sql
--- 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-08-20 11:21 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-20 04:56 TRIGGERS and FUNCTIONS ashok raj <ashokexplorer@gmail.com>
2007-08-20 11:21 ` Richard Broersma Jr <rabroersma@yahoo.com>
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