Re: resizing a varchar column on 8.3.8

Поиск
Список
Период
Сортировка
От Emi Lu
Тема Re: resizing a varchar column on 8.3.8
Дата
Msg-id 4D4186C5.5000608@encs.concordia.ca
обсуждение исходный текст
Ответ на resizing a varchar column on 8.3.8  (Jon Hoffman <jon@foursquare.com>)
Ответы Re: resizing a varchar column on 8.3.8
Список pgsql-general
On 01/15/2011 04:22 PM, Jon Hoffman wrote:
> Hi,
>
> I found a post with some instructions for resizing without locking up
> the table, but would like to get some re-assurance that this is the best
> way:
>
> http://sniptools.com/databases/resize-a-column-in-a-postgresql-table-without-changing-data
>
> How does that affect data storage and future updates on existing rows?

I did not see any feedbacks about this topic.

I need confirmation that it is safe to do this! Personally, I feel that
it is specially useful when there are many view dependencies. Update
from data dictionary, all views will be updated automatically, right?

Thanks a lot!
--
Lu Ying

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

Предыдущее
От: Lawrence Cohan
Дата:
Сообщение: Re: Adding ddl audit trigger
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Select query ignores index on large table