diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-06-09 18:28:00 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-06-09 18:28:00 +0000 |
| commit | 5862cda61147effec873c872b455a85f8127cf9b (patch) | |
| tree | 47cbe059004221c0eeb1b8c8d0c49b71356a79d1 | |
| parent | 837424605408c0772258291bf47e94f4d9111b9a (diff) | |
| download | postgresql-5862cda61147effec873c872b455a85f8127cf9b.tar.gz postgresql-5862cda61147effec873c872b455a85f8127cf9b.zip | |
Fix an ALTER TABLE test case so that it actually tests what the comment says it
is testing. Ah, the perils of making keywords optional ...
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 3 | ||||
| -rw-r--r-- | src/test/regress/sql/alter_table.sql | 2 |
2 files changed, 3 insertions, 2 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index e3aebc630d8..e7aef8bf59d 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -351,7 +351,8 @@ alter table atacc3 inherit atacc2; ERROR: child table is missing column "test2" -- fail due to mismatched data type alter table atacc3 add test2 bool; -alter table atacc3 add inherit atacc2; +alter table atacc3 inherit atacc2; +ERROR: child table "atacc3" has different type for column "test2" alter table atacc3 drop test2; -- succeed alter table atacc3 add test2 int; diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql index 46aacd1bef8..60ce47c47df 100644 --- a/src/test/regress/sql/alter_table.sql +++ b/src/test/regress/sql/alter_table.sql @@ -373,7 +373,7 @@ alter table atacc3 rename test2 to testx; alter table atacc3 inherit atacc2; -- fail due to mismatched data type alter table atacc3 add test2 bool; -alter table atacc3 add inherit atacc2; +alter table atacc3 inherit atacc2; alter table atacc3 drop test2; -- succeed alter table atacc3 add test2 int; |