pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren 5+ messages / 2 participants [nested] [flat]
* pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren @ 2022-10-05 18:06 Andres Freund <andres@anarazel.de> 0 siblings, 0 replies; 5+ messages in thread From: Andres Freund @ 2022-10-05 18:06 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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. Reviewed-by: Michael Paquier <michael@paquier.xyz> Discussion: https://postgr.es/m/20221003234111.4ob7yph6r4g4ywhu@awork3.anarazel.de Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/c3315a7da57be720222b119385ed0f7ad7c15268 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren @ 2024-09-26 04:47 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 5+ messages in thread From: Michael Paquier @ 2024-09-26 04:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_15_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/3981fd5869fc78296133bba5fd28586684835e5c 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren @ 2024-09-26 04:47 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 5+ messages in thread From: Michael Paquier @ 2024-09-26 04:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren @ 2024-09-26 04:47 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 5+ messages in thread From: Michael Paquier @ 2024-09-26 04:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/f232d7c6827c30e8f464dfa31cbe243ff6002ba9 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
* pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren @ 2024-09-26 04:47 Michael Paquier <michael@paquier.xyz> 0 siblings, 0 replies; 5+ messages in thread From: Michael Paquier @ 2024-09-26 04:47 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/81487c83bed99d715b0122d2c49f36390e6c15ad 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(-) ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2024-09-26 04:47 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-10-05 18:06 pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren Andres Freund <andres@anarazel.de> 2024-09-26 04:47 pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren Michael Paquier <michael@paquier.xyz> 2024-09-26 04:47 pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren Michael Paquier <michael@paquier.xyz> 2024-09-26 04:47 pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren Michael Paquier <michael@paquier.xyz> 2024-09-26 04:47 pgsql: tests: Restrict pg_locks queries in advisory_locks.sql to curren Michael Paquier <michael@paquier.xyz>
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