Postgres Pro
Downloads
Home   >   mailing lists

Re: How can I get and handle the status of sql statements that run inplpgsql ? - Mailing list pgsql-general

From David G. Johnston
Subject Re: How can I get and handle the status of sql statements that run inplpgsql ?
Date
Msg-id CAKFQuwZ7Tmg3GA+7RpAHtegK5CeMviYKv8_0X+kHEEhAwO_-Yg@mail.gmail.com
Whole thread Raw
In response to Re: How can I get and handle the status of sql statements that run inplpgsql ?  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: David Gauthier
Date:
Subject: Re: How can I get and handle the status of sql statements that run inplpgsql ?
Next
From: Pavel Stehule
Date:
Subject: Re: How can I get and handle the status of sql statements that run inplpgsql ?