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

From Andrus
Subject column "id" is of type integer but expression is of type character
Date
Msg-id 550FA46EDB07485183DEF8FAB1CC998C@andrusnotebook
Whole thread Raw
Responses Re: column "id" is of type integer but expression is of type character  (Raymond O'Donnell <rod@iol.ie>)
Re: column "id" is of type integer but expression is of type character  (Alan Hodgson <ahodgson@simkin.ca>)
Re: column "id" is of type integer but expression is of type character  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Dan Armbrust"
Date:
Subject: Re: Slow Vacuum was: vacuum output question
Next
From: Raymond O'Donnell
Date:
Subject: Re: column "id" is of type integer but expression is of type character