Re: Triggers, functions and column names: a poser

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.

In response to

Browse pgsql-general by date

  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