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
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.
pgadmin-support by date
|Next:||From: Dave Page||Date: 2003-06-17 10:58:53|
|Subject: Re: Alter Column Wizard?|
|Previous:||From: Dave Page||Date: 2003-06-16 12:26:22|
|Subject: Re: Error Message|