Re: access to original-statement predicates in an INSTEAD-OF row trigger - Mailing list pgsql-general

From Tom Lane
Subject Re: access to original-statement predicates in an INSTEAD-OF row trigger
Date
Msg-id 29541.1573918633@sss.pgh.pa.us
Whole thread Raw
In response to Re: access to original-statement predicates in an INSTEAD-OF rowtrigger  (John Lumby <johnlumby@hotmail.com>)
List pgsql-general
John Lumby <johnlumby@hotmail.com> writes:
> How can a row trigger access the original SQL statement at the root of 
> the current operation?

It can't; at least not in any way that'd be reliable or maintainable.

I concur with the upthread recommendation that switching to serializable
mode would be a more manageable way of dealing with concurrent-update
problems.

            regards, tom lane



pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Function performance degrades after repeated execution
Next
From: Ron
Date:
Subject: Re: Function performance degrades after repeated execution