From fecc04f95a136bbfbded44c476d597eed6ac6258 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 4 Aug 2002 04:28:10 +0000 Subject: [PATCH] This patch fixes in intermittent failure in the regression tests: there was a race condition between the "alter_table" and "rules" regression tests. Depending on scheduling, sometimes an ALTER TABLE command would operate on a relation created by the "rules" tests, leading to unexpected results. Neil Conway --- src/test/regress/expected/alter_table.out | 8 ++++---- src/test/regress/sql/alter_table.sql | 4 ++-- 2 files changed, 6 insertions(+), 6 deletions(-) diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 741b012c28..3833600f2b 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -615,10 +615,10 @@ ERROR: ALTER TABLE: relation "pg_class" is a system catalog alter table pg_class alter relname set not null; ERROR: ALTER TABLE: relation "pg_class" is a system catalog -- try altering non-existent table, should fail -alter table foo alter column bar set not null; -ERROR: Relation "foo" does not exist -alter table foo alter column bar drop not null; -ERROR: Relation "foo" does not exist +alter table non_existent alter column bar set not null; +ERROR: Relation "non_existent" does not exist +alter table non_existent alter column bar drop not null; +ERROR: Relation "non_existent" does not exist -- test setting columns to null and not null and vice versa -- test checking for null values and primary key create table atacc1 (test int not null); diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 8946d2b15b..6eaae24fa8 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -478,8 +478,8 @@ alter table pg_class alter column relname drop not null; alter table pg_class alter relname set not null; -- try altering non-existent table, should fail -alter table foo alter column bar set not null; -alter table foo alter column bar drop not null; +alter table non_existent alter column bar set not null; +alter table non_existent alter column bar drop not null; -- test setting columns to null and not null and vice versa -- test checking for null values and primary key -- 2.40.0