Re: ALTER TABLE & COLUMN

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: ALTER TABLE & COLUMN
Дата
Msg-id x77keqzywc.fsf@onceler.kciLink.com
обсуждение исходный текст
Ответ на Re: ALTER TABLE & COLUMN  (Neil Conway <neilc@samurai.com>)
Список pgsql-general
>>>>> "NC" == Neil Conway <neilc@samurai.com> writes:

NC> problem leaving this in the hands of the admin. The one exception might
NC> be changing the length limit on a varchar(n) column, but that's such a
NC> small case I'm not sure it's worth the bother (and can be done by
NC> hacking the system catalogs anyway).

That's a PITA to do, and scares the willies out of mere mortals,
myself included.  Doing a add column, rename old, copy data, rename
new is also a PITA, and I'm not sure the effects of that on foreign
keys that my reference that column.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Ed L.
Дата:
Сообщение: 7.3 pg_ctl anomaly
Следующее
От: Hunter Hillegas
Дата:
Сообщение: Re: 7.3 on OS X HOWTO