| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jon Horsman | 2007-08-20 15:47:12 | Re: When is a shared library unloaded? |
| Previous Message | ashok raj | 2007-08-20 04:56:46 | TRIGGERS and FUNCTIONS |