Re: changing varchar limits

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: changing varchar limits
Дата
Msg-id 28772.1028329619@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: changing varchar limits  (Kevin Brannen <kevinb@nurseamerica.net>)
Список pgsql-general
Kevin Brannen <kevinb@nurseamerica.net> writes:
> To easily change a column from nullable to not-nullable, is flipping the
> proper attribute all that's required?  Just asking, cause it would be
> very useful until there's an ALTER TABLE equivalent (in 7.3?).

Sure, just flip the bit (though if you're going to the not-nullable
state, it's your responsibility to make sure the existing data is in
fact not null).  This is basically what the 7.3 implementation does.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Creating GiST Indices?
Следующее
От: Arguile
Дата:
Сообщение: Re: Postgres and Perl: Which DBI module?