Hi,
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