Re: How can I get and handle the status of sql statements that run inplpgsql ?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How can I get and handle the status of sql statements that run inplpgsql ?
Дата
Msg-id CAKFQuwZ7Tmg3GA+7RpAHtegK5CeMviYKv8_0X+kHEEhAwO_-Yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How can I get and handle the status of sql statements that run inplpgsql ?  (David Gauthier <davegauthierpg@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Wed, Oct 3, 2018 at 9:25 AM, David Gauthier <davegauthierpg@gmail.com> wrote:
Is that how you detect if nothing was updated


Given your concerns and examples you might also want to look into serializable isolation; it is much more robust.

https://www.postgresql.org/docs/10/static/transaction-iso.html#XACT-SERIALIZABLE

If your concern isn't related to concurrency though you should just setup tests to ensure the coding logic is correct and then let it run without all the double-checking in production.

David J.

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

Предыдущее
От: David Gauthier
Дата:
Сообщение: Re: How can I get and handle the status of sql statements that run inplpgsql ?
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How can I get and handle the status of sql statements that run inplpgsql ?