pgsql: Replace alter_table.sql test usage of event triggers. - Mailing list pgsql-committers

From Andres Freund
Subject pgsql: Replace alter_table.sql test usage of event triggers.
Date
Msg-id E1iKfv6-0002o5-W9@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Replace alter_table.sql test usage of event triggers.

The test in 93765bd956b added an event trigger to ensure that the
tested table rewrites do not get optimized away (as happened in the
past). But doing so would require running the tests in isolation, as
otherwise the trigger might also fire in concurrent sessions, causing
test failures there.

Reported-By: Tom Lane
Discussion: https://postgr.es/m/3328.1570740683@sss.pgh.pa.us
Backpatch: 12, just as 93765bd956b

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/3b25de62099cf954ea0ca1fe5d70dbc3fbb776c5

Modified Files
--------------
src/test/regress/expected/alter_table.out | 105 +++++++++++++++++++++---------
src/test/regress/sql/alter_table.sql      |  71 ++++++++++++--------
2 files changed, 116 insertions(+), 60 deletions(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Replace alter_table.sql test usage of event triggers.
Next
From: Tomas Vondra
Date:
Subject: pgsql: Improve the check for pg_catalog.line data type in pg_upgrade