From: | Grant Table <grant(dot)table(at)easypublish(dot)de> |
---|---|
To: | "Gurunandan R(dot) Bhat" <grbhat(at)exocore(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Triggers, functions and column names: a poser |
Date: | 2001-11-17 08:55:22 |
Message-ID: | 200111170856.JAA14587@post.webmailer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday 17 November 2001 04:53, Gurunandan R. Bhat wrote:
>
> Hi,
>
> I had just written one such beast recently which in addition to
> what you want also writes the values of the updated/inserted fields as a
> serialised string. I wrote this primarily to replicate two databases with
> a perlscript that reads this "logtable" and then talks to a remote
> database with an expect-send sequence. I am currently writing an article
> describing this which I was planning to submit to the
> techdocs.postgresql.org site. IAC here's the code. I have also included
> the droptrigger utility which well .. drops the triggers should something
> bad happen. Hope you find this useful.
(code snipped)
Hi
many thanks for the reply and the code. Pointed me in the right direction :-))
(as it happens a selective limited replication probably using a
cronjob-triggered Perl script is one aim of the action).
Thanks again
Grant.
From | Date | Subject | |
---|---|---|---|
Next Message | wyatt | 2001-11-17 20:55:42 | One time only trigger/function on every row... |
Previous Message | James Huang | 2001-11-17 07:58:07 | [ANN] A Genuine JDBC Scripting Language |