Re: Updating pg_attribute to change field's data type from integer to bigint on very large table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Дата
Msg-id 24395.1334330848@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Updating pg_attribute to change field's data type from integer to bigint on very large table  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Список pgsql-general
I wrote:
> No, that is an actual on-disk change (making the field physically
> wider), so it's going to cost ya.  There are some cases where the
> on-disk representation doesn't change and so a catalog update isn't
> needed, but int4->int8 isn't one of them.

Sheesh, hit send too quickly on that.  Of course I meant "and so a
catalog update is all that's needed".

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Следующее
От: Jeff Adams
Дата:
Сообщение: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table