i mailed to the postgresql-general list in order to clearify, why there is no full alter table/alter column command yet. One cannot change the column-type of a column with one command. You need to create a new column, copy data, delete the old one, recreate all constraints, indexes etc.
This would be a beautiful feature for pgAdmin II/III.
It might be easy or not - depending on your program-structure. If you can easily create one Object fr each Index/Constriant etc., it might be easy to drop them, keep them saved in memory and recreate them - all within a transaction if possible.
That one can't change column-definition is the most anoying thing about postgresql, so it would be great to overcome that problem - even if it's only with a tool like pgAdmin.
Thx Sven
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
