Re: column "id" is of type integer but expression is of type character - Mailing list pgsql-general

Andrus wrote:
> 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.

> How to fix ?

Don't use SELECT * - list the columns you want to insert. I can't think
why you would do that (you'll end up with nulls in the id column) but it
will work.

--
  Richard Huxton
  Archonet Ltd