On Wed, Oct 3, 2018 at 9:25 AM, David Gauthier <davegauthie...@gmail.com>
wrote:

> Is that how you detect if nothing was updated
>

https://www.postgresql.org/docs/10/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

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.

Reply via email to