aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-06-09 18:28:00 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-06-09 18:28:00 +0000
commit5862cda61147effec873c872b455a85f8127cf9b (patch)
tree47cbe059004221c0eeb1b8c8d0c49b71356a79d1 /src
parent837424605408c0772258291bf47e94f4d9111b9a (diff)
downloadpostgresql-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 ...
Diffstat (limited to 'src')
-rw-r--r--src/test/regress/expected/alter_table.out3
-rw-r--r--src/test/regress/sql/alter_table.sql2
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;