> (Postgres 7.2.1)
>
> I screwed up when I was designing a table a while back and made a column a
> VARCHAR that referenced (and should have been) an INT.
>
> Now I'm trying to correct my mistake, I've created a new table and I'm
> trying to INSERT INTO...SELECT the data into it, but it's complaining that
> it can't stick a VARCHAR into an INT. All the values in the column are valid
> integers (the foreign key sees to that) but even a CAST won't do it.
>
> How can I force it to copy/change the values?
>
varchar cannot be casted to integer directly. Rather we can do it this
way:
=> select your_varchar_field::text::int from your_table;
regards,
bhuvaneswaran