diff options
Diffstat (limited to 'src/test/regress/expected/alter_table.out')
| -rw-r--r-- | src/test/regress/expected/alter_table.out | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/test/regress/expected/alter_table.out b/src/test/regress/expected/alter_table.out index 15179540a2d..388e25e9dba 100644 --- a/src/test/regress/expected/alter_table.out +++ b/src/test/regress/expected/alter_table.out @@ -1301,7 +1301,7 @@ select f3,max(f1) from foo group by f3; -- Simple tests for alter table column type alter table foo alter f1 TYPE integer; -- fails -ERROR: column "f1" cannot be cast to type "pg_catalog.int4" +ERROR: column "f1" cannot be cast to type integer alter table foo alter f1 TYPE varchar(10); create table anothertab (atcol1 serial8, atcol2 boolean, constraint anothertab_chk check (atcol1 <= 3)); @@ -1316,7 +1316,7 @@ select * from anothertab; (2 rows) alter table anothertab alter column atcol1 type boolean; -- fails -ERROR: column "atcol1" cannot be cast to type "pg_catalog.bool" +ERROR: column "atcol1" cannot be cast to type boolean alter table anothertab alter column atcol1 type integer; select * from anothertab; atcol1 | atcol2 @@ -1350,7 +1350,7 @@ select * from anothertab; alter table anothertab alter column atcol1 type boolean using case when atcol1 % 2 = 0 then true else false end; -- fails -ERROR: default for column "atcol1" cannot be cast to type "pg_catalog.bool" +ERROR: default for column "atcol1" cannot be cast to type boolean alter table anothertab alter column atcol1 drop default; alter table anothertab alter column atcol1 type boolean using case when atcol1 % 2 = 0 then true else false end; -- fails |