Re: Reference new.* or old.* in dynamic statement? - Mailing list pgsql-general

From Tom Lane
Subject Re: Reference new.* or old.* in dynamic statement?
Date
Msg-id 16663.1123602873@sss.pgh.pa.us
Whole thread Raw
In response to Reference new.* or old.* in dynamic statement?  (Jeff Boes <jeff@endpoint.com>)
List pgsql-general
Jeff Boes <jeff@endpoint.com> writes:
> I'm trying to write a general-purpose trigger that will disallow updates
> on certain fields (I could probably do this in other ways, but I have a
> stubborn streak ...).

I think it's pretty much impossible to do this in plpgsql.  You could do
it in the other PLs that support triggers, or in C.  From a performance
standpoint I'd think you'd want to do it in C anyway.  There are some
closely related example trigger functions in the contrib tree.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: postgres & server encodings
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Case sensitivity