full featured alter table?
Sven Köhler <skoehler@upb.de>
From: Sven Koehler <skoehler@upb.de>
To: pgsql-general@postgresql.org
Date: 2003-06-12T14:20:16Z
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.