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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Дата
Msg-id 6ea3b732-1f37-41c9-29a1-65f3aaebb6cd@aklaver.com
обсуждение исходный текст
Ответ на Re: access to original-statement predicates in an INSTEAD-OF rowtrigger  (John Lumby <johnlumby@hotmail.com>)
Ответы Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Список 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.klaver@aklaver.com

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

Предыдущее
От: John Lumby
Дата:
Сообщение: Re: access to original-statement predicates in an INSTEAD-OF rowtrigger
Следующее
От: Palle Girgensohn
Дата:
Сообщение: Re: here does postgres take its timezone information from?