pgsql: Fix transaction.sql tests in higher isolation levels.

From: Thomas Munro <tmunro(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix transaction.sql tests in higher isolation levels.
Date: 2021-03-17 04:28:11
Message-ID: E1lMNn1-0001av-Nh@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(at)sss(dot)pgh(dot)pa(dot)us>
Discussion: https://postgr.es/m/CA%2BhUKGJUaHeK%3DHLATxF1JOKDjKJVrBKA-zmbPAebOM0Se2FQRg%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/37929599499fe5760a9dbab48a10a898879a0d44

Modified Files
--------------
src/test/regress/expected/transactions.out | 2 ++
src/test/regress/sql/transactions.sql | 4 ++++
2 files changed, 6 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2021-03-17 05:14:48 pgsql: Fix race in Parallel Hash Join batch cleanup.
Previous Message Amit Kapila 2021-03-17 02:47:20 pgsql: Fix race condition in drop subscription's handling of tablesync