full featured alter table? - Mailing list pgsql-general

From Sven Koehler
Subject full featured alter table?
Date
Msg-id bca224$mi8$1@main.gmane.org
Whole thread Raw
Responses Re: full featured alter table?  (Jonathan Bartlett <johnnyb@eskimo.com>)
Re: full featured alter table?  ("scott.marlowe" <scott.marlowe@ihs.com>)
full featured alter table/column ordering - a summary  (Sven Koehler <skoehler@upb.de>)
List 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.


pgsql-general by date:

Previous
From: sector119@mail.ru
Date:
Subject: tsearch - v2
Next
From: Jonathan Bartlett
Date:
Subject: Re: full featured alter table?