Postgres Pro
Downloads
Home   >   mailing lists

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

From John Lumby
Subject Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Date
Msg-id DM6PR06MB5562FB8507E487AD13F2D655A3700@DM6PR06MB5562.namprd06.prod.outlook.com
Whole thread Raw
In response to access to original-statement predicates in an INSTEAD-OF row trigger  (John Lumby <johnlumby@hotmail.com>)
Responses Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Next
From: Adrian Klaver
Date:
Subject: Re: access to original-statement predicates in an INSTEAD-OF rowtrigger