| 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: | Whole Thread | Raw Message | 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 |