Commit88d45ac

committed

Fix alter_system_table test

Add workaround for disabling ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONSwarning for the test that tries to create a tablespace with a reservedname.Discussion:https://www.postgresql.org/message-id/flat/E1iacW7-0003h6-6U%40gemulon.postgresql.org

1 parent9989d37 commit88d45acCopy full SHA for 88d45ac

File tree

-0

lines changed

-0

lines changed

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -152,8 +152,10 @@ BEGIN;`
`152`	`152`	`ALTER TABLE pg_description SET SCHEMA public;`
`153`	`153`	`ROLLBACK;`
`154`	`154`	`-- reserved tablespace name`
	`155`	`+SET client_min_messages = error; -- disable ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS warning`
`155`	`156`	`CREATE TABLESPACE pg_foo LOCATION '/no/such/location';`
`156`	`157`	`ERROR: directory "/no/such/location" does not exist`
	`158`	`+RESET client_min_messages;`
`157`	`159`	`-- triggers`
`158`	`160`	`CREATE TRIGGER t1 BEFORE INSERT ON pg_description EXECUTE FUNCTION tf1();`
`159`	`161`	`ALTER TRIGGER t1 ON pg_description RENAME TO t2;`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -166,7 +166,9 @@ ALTER TABLE pg_description SET SCHEMA public;`
`166`	`166`	`ROLLBACK;`
`167`	`167`
`168`	`168`	`-- reserved tablespace name`
	`169`	`+SET client_min_messages= error;-- disable ENFORCE_REGRESSION_TEST_NAME_RESTRICTIONS warning`
`169`	`170`	`CREATETABLESPACEpg_foo LOCATION'/no/such/location';`
	`171`	`+RESET client_min_messages;`
`170`	`172`
`171`	`173`	`-- triggers`
`172`	`174`	`CREATETRIGGERt1 BEFORE INSERTON pg_description EXECUTE FUNCTION tf1();`

Comments

(0)