Re: alter column type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: alter column type
Дата
Msg-id 26382.1433533372@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: alter column type  (Casey Deccio <casey@deccio.net>)
Список pgsql-general
Casey Deccio <casey@deccio.net> writes:
> Being unfamiliar with the internals, what's the risk here?  If postgres
> thinks something is a bigint, but previously stored it as an int, does that
> mean it will try to extract data beyond the boundary of some of the (old)
> 32-bit values and potentially throw off offsets for other values?

Yes.  This *will* break your table, spectacularly.  The other person who
was opining that it would work has no understanding of the actual storage
layout.

            regards, tom lane


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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: [PERFORM] Re: Re: Query running slow for only one specific id. (Postgres 9.3) version
Следующее
От: John R Pierce
Дата:
Сообщение: Re: alter column type