Re: Changing size of varchar field

Поиск
Список
Период
Сортировка
От dan radom
Тема Re: Changing size of varchar field
Дата
Msg-id 20021025011001.GB2612@lunar.radom.org
обсуждение исходный текст
Ответ на Changing size of varchar field  (cg <chris.gamble@cpbinc.com>)
Список pgsql-general
* cg (chris.gamble@cpbinc.com) wrote:
> I recently saw on this list a way to change the length of a varchar
> field using the pg_atttypemod table. My question is: is this safe on a
> database with data? Are there any drawbacks to doing this and is there
> any plan to make this a standard usable feature?
>

i think with any modification you should always pg_dump the database.  if
all hell breaks lose you can always go back to the point you were at
before the change.

dan

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

Предыдущее
От: "John"
Дата:
Сообщение: Error on import
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Error on import