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

From: John Lumby <johnlumby(at)hotmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(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 21:54:12
Message-ID: DM6PR06MB5562FB8507E487AD13F2D655A3700@DM6PR06MB5562.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Cheers, John

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-11-15 22:38:14 Re: access to original-statement predicates in an INSTEAD-OF row trigger
Previous Message Adrian Klaver 2019-11-15 21:22:52 Re: access to original-statement predicates in an INSTEAD-OF row trigger