From: | "Andy Dale" <andy(dot)dale(at)gmail(dot)com> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | "pgsql general" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Generic triggers ? |
Date: | 2007-04-24 17:43:03 |
Message-ID: | faa313130704241043mb47c5barb76c90d518740c4f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)archonet(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-04-24 17:57:27 | Re: PG service restart failure (start getting ahead of stop?) |
Previous Message | Dan Shea | 2007-04-24 17:31:19 | Re: View is not using a table index |