Skip site navigation (1) Skip section navigation (2)

Alter Column Wizard?

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 (view raw or flat)
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



pgadmin-support by date

Next:From: Dave PageDate: 2003-06-17 10:58:53
Subject: Re: Alter Column Wizard?
Previous:From: Dave PageDate: 2003-06-16 12:26:22
Subject: Re: Error Message

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group