Re: Generic triggers ? - Mailing list pgsql-general

From Andy Dale
Subject Re: Generic triggers ?
Date
Msg-id faa313130704241043mb47c5barb76c90d518740c4f@mail.gmail.com
Whole thread Raw
In response to Re: Generic triggers ?  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Thanks for the quick response, i think will try it with python or perl.


Cheers,

Andy

On 24/04/07, Richard Huxton < dev@archonet.com> wrote:
Andy Dale wrote:
> Hi,
>
> I wanted to setup a simple "generic" type trigger.  What a mean by generic
> is that i don't want to hardcode the
> NEW.<column> or OLD.<column> calls, i searched for a way to loop over
> the NEW/OLD rowtypes but could not figure out how it should be done.

Don't use plpgsql - that's the secret. Try pltcl or plperl or similar.
PL/pgsql is a bit too "statically typed" for it.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "George Pavlov"
Date:
Subject: Re: PG service restart failure (start getting ahead of stop?)
Next
From: "Michael Nolan"
Date:
Subject: WAL files, warm spares and minor versions