Ok. I've reproduced this but I now think that it isn't a bug.
My schemas initially weren't the symetric when I was using select *. Alas,
when I did align my schemas later, I had already switched to specifying a
column list which then did not match the column list in the table. An
improvement
"Gray Watson" writes:
> I have 2 tables which have the same schema (as far as I can see) but when I
> try to do the following in psql:
> INSERT INTO old_log SELECT * FROM log WHERE time < '2010-02-01';
> I get the error:
> ERROR: column "port" is of type integer but expression is of type charac
The following bug has been logged online:
Bug reference: 5372
Logged by: Gray Watson
Email address: gray...@mailnull.com
PostgreSQL version: 8.3.9
Operating system: debian linux
Description:insert into fails with integer expression type char
error
Details:
I have 2
