Fix transaction.sql tests in higher isolation levels.
authorThomas Munro <tmunro@postgresql.org>
Wed, 17 Mar 2021 04:13:43 +0000 (17:13 +1300)
committerThomas Munro <tmunro@postgresql.org>
Wed, 17 Mar 2021 04:26:20 +0000 (17:26 +1300)
commit37929599499fe5760a9dbab48a10a898879a0d44
treef50f86e86784b378ab5ce87b58053ed1c5b0c154
parent6b67d72b604cb913e39324b81b61ab194d94cba0
Fix transaction.sql tests in higher isolation levels.

It seems like a useful sanity check to be able to run "installcheck"
against a cluster running with default_transaction_level set to
serializable or repeatable read.  Only one thing currently fails in
those configurations, so let's fix that.

No back-patch for now, because it fails in many other places in some of
the stable branches.  We'd have to go back and fix those too if we
included this configuration in automated testing.

Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/CA%2BhUKGJUaHeK%3DHLATxF1JOKDjKJVrBKA-zmbPAebOM0Se2FQRg%40mail.gmail.com
src/test/regress/expected/transactions.out
src/test/regress/sql/transactions.sql