Re: [BUGS] BUG #5372: insert into fails with integer expression type char error

2010-03-12 Thread gray . pg
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

Re: [BUGS] BUG #5372: insert into fails with integer expression type char error

2010-03-12 Thread Tom Lane
"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