On 08/01/2009 19:04, Andrus wrote: > 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. Well, you've dropped the integer column from test, so now the INSERT command is trying to stuff the char(10) value from test into the integer column in lisa - which is what the error message is telling you. I've no idea, in any case, whether you can expect SELECTing two columns into a one-column table to work. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
