Forum OpenACS Q&A: Response to alter column type problem.

Collapse
4: Response to alter column type problem. (response to 1)
Posted by Janine Ohmer on 06/20/01 07:39 PM
Ah, well you can't do what you're trying to do this way.  Postgres
doesn't know you want to do a conversion, it thinks you're making
a mistake.

AFAIK  you'll have to write a script which loops through the
source table and inserts into the destination table.  Maybe the
Postgres experts here know of a shortcut, but that's the only way I
know to do it.