full featured alter table?

Поиск
Список
Период
Сортировка
От Sven Koehler
Тема full featured alter table?
Дата
Msg-id bca224$mi8$1@main.gmane.org
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: sector119@mail.ru
Дата:
Сообщение: tsearch - v2
Следующее
От: Jonathan Bartlett
Дата:
Сообщение: Re: full featured alter table?