From: Michael Paquier <michael@paquier.xyz>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren
Date: Thu, 26 Sep 2024 04:47:25 +0000
Message-ID: <E1stgPU-000yQJ-JM@gemulon.postgresql.org> (raw)
tests: Restrict pg_locks queries in advisory_locks.sql to current database
Otherwise testing an existing installation can fail, if there are other locks,
e.g. from one of the isolation tests.
This was originally applied as c3315a7da57b in 16~, but it is possible
to see this test fail depending on the concurrent activity for older
active branches.
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/20221003234111.4ob7yph6r4g4ywhu@awork3.anarazel.de
Backpatch-through: 12
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/e750e413325e7e2d1979efd82c212e3a91025435
Author: Andres Freund <andres@anarazel.de>
Modified Files
--------------
src/test/regress/expected/advisory_lock.out | 31 ++++++++++++++--------------
src/test/regress/sql/advisory_lock.sql | 32 +++++++++++++++--------------
2 files changed, 33 insertions(+), 30 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: michael@paquier.xyz, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren
In-Reply-To: <E1stgPU-000yQJ-JM@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox