From: | Sven Koehler <skoehler(at)upb(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | full featured alter table? |
Date: | 2003-06-12 14:20:16 |
Message-ID: | bca224$mi8$1@main.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
one of the biggest disease of PostGreSQL is, that i can't change the
definition of a column.
In order to do that, i'd have to drop any keys, drop the column and
create a new one with all indexes etc.
Are there any plans to overcome that problem?
Even simple changes like varchar(20) to varchar(200) are not allowed.
I asked this question about 2 years ago, and there were only some guys,
that told me that i wouldn't need to change my DB if i'd plan it well.
So my DB is planned well, but i have to change it every now and than
because i must implement the changes that my client demands me to do,
and have some extra work that nobody will pay me for, if there's no way
to change a column.
This is the only missing feature, that prevent me to use this DBMS - i'd
love to, because it's an ORDBMS and that's what i'd have needed sometimes.
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Bartlett | 2003-06-12 14:26:49 | Re: full featured alter table? |
Previous Message | sector119 | 2003-06-12 14:16:43 | tsearch - v2 |