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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: access to original-statement predicates in an INSTEAD-OF row trigger
Дата
Msg-id 29541.1573918633@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: access to original-statement predicates in an INSTEAD-OF rowtrigger  (John Lumby <johnlumby@hotmail.com>)
Список pgsql-general
John Lumby <johnlumby@hotmail.com> writes:
> How can a row trigger access the original SQL statement at the root of 
> the current operation?

It can't; at least not in any way that'd be reliable or maintainable.

I concur with the upthread recommendation that switching to serializable
mode would be a more manageable way of dealing with concurrent-update
problems.

            regards, tom lane



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Function performance degrades after repeated execution
Следующее
От: Ron
Дата:
Сообщение: Re: Function performance degrades after repeated execution