Commands:
create temp table test ( id int, baas char(10) );
create temp table lisa ( id int, baas char(10) );
alter table lisa drop column id;
INSERT INTO test SELECT * FROM lisa;
drop table lisa;
Cause error
ERROR: column "id" is of type integer but expression is of type character
HINT: You will need to rewrite or cast the expression.
********** Error **********
ERROR: column "id" is of type integer but expression is of type character
SQL state: 42804
Hint: You will need to rewrite or cast the expression.
How to fix ?
Andrus.