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

Поиск
Список
Период
Сортировка
От John Lumby
Тема Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Дата
Msg-id DM6PR06MB5562FB8507E487AD13F2D655A3700@DM6PR06MB5562.namprd06.prod.outlook.com
обсуждение исходный текст
Ответ на access to original-statement predicates in an INSTEAD-OF row trigger  (John Lumby <johnlumby@hotmail.com>)
Ответы Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: access to original-statement predicates in an INSTEAD-OF rowtrigger