pgsql: Fix test failure with wal_level=minimal.

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix test failure with wal_level=minimal.
Date: 2021-01-13 19:00:04
Message-ID: E1kzlNE-0008Vz-GC@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix test failure with wal_level=minimal.

The newly-added gist pageinspect test prints the LSNs of GiST pages,
expecting them all to be 1 (GistBuildLSN). But with wal_level=minimal,
they got updated by the whole-relation WAL-logging at commit. Fix by
wrapping the problematic tests in the same transaction with the CREATE
INDEX.

Per buildfarm failure on thorntail.

Discussion: https://www.postgresql.org/message-id/3B4F97E5-40FB-4142-8CAA-B301CDFBF982%40iki.fi

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5abca4b1cd7193d6a5c8235c97eb240312190bcb

Modified Files
--------------
contrib/pageinspect/expected/gist.out | 10 ++++++++++
contrib/pageinspect/sql/gist.sql | 12 ++++++++++++
2 files changed, 22 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2021-01-13 19:53:17 pgsql: Disallow a digit as the first character of a variable name in pg
Previous Message Tom Lane 2021-01-13 18:30:24 pgsql: Doc: clarify behavior of back-half options in pg_dump.