Re: Damn triggers and NEW - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: Damn triggers and NEW
Date
Msg-id Pine.LNX.4.21.0306171155010.5417-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Damn triggers and NEW  (Joe Conway <mail@joeconway.com>)
List pgsql-general
On Tue, 17 Jun 2003, Joe Conway wrote:

> Nigel J. Andrews wrote:
> > I'd appreciate some pointers on this as it appears new/old can't be used in an
> > execute statement in triggers but that sounds completely wrong.
> >
>
> I've tried this before, and unfortunately I think that statement is
> currently true. I dug in to it one day and it didn't look too easy to
> fix either (no big surprise there, otherwise someone probably would have
> already fixed it ;-))
>
> I ended up concluding that, short of a patch to the backend, a C code
> trigger would be needed. You might be able to do something with pltcl or
>   one of the other PLs though.

Ok, thanks Joe. That's what I was thinking I might have to do, a C code
version that is.


--
Nigel J. Andrews


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Sort memory not being released
Next
From: "Bruno BAGUETTE"
Date:
Subject: RE : full featured alter table?