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