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