Re: access to original-statement predicates in an INSTEAD-OF row trigger

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: John Lumby <johnlumby(at)hotmail(dot)com>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: access to original-statement predicates in an INSTEAD-OF row trigger
Date: 2019-11-15 22:38:14
Message-ID: 6ea3b732-1f37-41c9-29a1-65f3aaebb6cd@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/15/19 1:54 PM, John Lumby wrote:
> Adrian Klaver wrote :
>>
>> Seems you are looking for Serializable Isolation Level:
>>
>
> True ,   that would solve the race condition,  but it is too drastic.
> We need to run with Read Committed.
>
> I am looking for a solution which does not alter the application or
> overall behaviour,
> but just addresses detecting which predicates to apply in some way.

Not sure how that could be pulled off with Read Committed as it would
involve predicting the future from the POV of the transaction.

>
> Cheers,  John
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Palle Girgensohn 2019-11-15 23:35:34 Re: here does postgres take its timezone information from?
Previous Message John Lumby 2019-11-15 21:54:12 Re: access to original-statement predicates in an INSTEAD-OF row trigger