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.