From: | Sven Köhler <skoehler(at)upb(dot)de> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Alter Column Wizard? |
Date: | 2003-06-16 17:04:13 |
Message-ID: | 3EEDF88D.6060404@upb.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2003-06-17 10:58:53 | Re: Alter Column Wizard? |
Previous Message | Dave Page | 2003-06-16 12:26:22 | Re: Error Message |