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

Поиск
Список
Период
Сортировка
От Jeff Adams
Тема Updating pg_attribute to change field's data type from integer to bigint on very large table
Дата
Msg-id CA+BdxK-MG+88wHbXRbeFNgJtFYnHdHb3xxejve_FSZP_6z=4Nw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Список pgsql-general
Greetings,

I have a very large table (approximately 1 billion records). I need to change a field's data type from integer to bigint. I started up an ALTER TABLE approach yesterday and it is still running (trying to rewrite the whole table?). I remember seeing mention of being able to do this in the pg_attribute table. Has anybody ever used the latter approach. If so, instructions would be greatly appreciated. Thanks...

Jeff


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

Предыдущее
От: Bruno Lavoie
Дата:
Сообщение: Re: recommended schema diff tools?
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: aggregate arrays