From 88d45ac752ae49dbfafeb163b07381d3b8a6b601 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Tue, 3 Dec 2019 09:14:35 +0100 Subject: [PATCH] Fix alter_system_table test Add workaround for disabling ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS warning for the test that tries to create a tablespace with a reserved name. Discussion: https://www.postgresql.org/message-id/flat/E1iacW7-0003h6-6U%40gemulon.postgresql.org --- src/test/modules/unsafe_tests/expected/alter_system_table.out | 2 ++ src/test/modules/unsafe_tests/sql/alter_system_table.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/src/test/modules/unsafe_tests/expected/alter_system_table.out b/src/test/modules/unsafe_tests/expected/alter_system_table.out index 09a557f837a..ca7eabe9bbc 100644 --- a/src/test/modules/unsafe_tests/expected/alter_system_table.out +++ b/src/test/modules/unsafe_tests/expected/alter_system_table.out @@ -152,8 +152,10 @@ BEGIN; ALTER TABLE pg_description SET SCHEMA public; ROLLBACK; -- reserved tablespace name +SET client_min_messages = error; -- disable ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS warning CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; ERROR: directory "/no/such/location" does not exist +RESET client_min_messages; -- triggers CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); ALTER TRIGGER t1 ON pg_description RENAME TO t2; diff --git a/src/test/modules/unsafe_tests/sql/alter_system_table.sql b/src/test/modules/unsafe_tests/sql/alter_system_table.sql index 60769c8d51c..44cb3c7148a 100644 --- a/src/test/modules/unsafe_tests/sql/alter_system_table.sql +++ b/src/test/modules/unsafe_tests/sql/alter_system_table.sql @@ -166,7 +166,9 @@ ALTER TABLE pg_description SET SCHEMA public; ROLLBACK; -- reserved tablespace name +SET client_min_messages = error; -- disable ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS warning CREATE TABLESPACE pg_foo LOCATION '/no/such/location'; +RESET client_min_messages; -- triggers CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1(); -- 2.39.5