Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3
Дата
Msg-id 20140526050533.GH18867@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: pg_upgrade fails: Mismatch of relation OID in database 8.4 -> 9.3  (Jeff Ross <jeff@commandprompt.com>)
Список pgsql-hackers
Hi,

On 2014-05-25 16:59:24 -0600, Jeff Ross wrote:
> Could a check like this be added to pg_upgrade?
> Is there a downside to
> adding a column big enough to force a toast table and then dropping it for
> any table that is too large not to have a toast table but doesn't?

It can take time and permanently 'uses up' a attribute number. So you'd
add costs for everyone for the few people that decided to do something
dangerous and unsupported...

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: relaying errors from background workers
Следующее
От: Andres Freund
Дата:
Сообщение: Re: 9.4 btree index corruption