Re: [RFC] Removing "magic" oids

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [RFC] Removing "magic" oids
Дата
Msg-id 20181027185656.2jiit4epdpk46dlh@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [RFC] Removing "magic" oids  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: [RFC] Removing "magic" oids  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Hi,

On 2018-10-28 00:21:23 +0530, Amit Kapila wrote:
> On Sun, Sep 30, 2018 at 9:18 AM Andres Freund <andres@anarazel.de> wrote:
> > I think we should drop WITH OIDs support.  pg_dump should convert WITH
> > OIDs tables into tables that have an explicit oid column (with an
> > appropriate default function), pg_upgrade should refuse to upgrade them.
> >
> 
> Is there any technical reason why you think pg_upgrade should refuse
> to upgrade them?  I think there is an argument to break backward
> compatibility here and many people on the thread seem to be okay with
> that, but refusing to upgrade sounds more restrictive.

They'd not be on-disk compatible, because the column isn't stored as a
normal column but in the t_hoff space.

Greetings,

Andres Freund


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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: [RFC] Removing "magic" oids
Следующее
От: Narayanan V
Дата:
Сообщение: Re: Postgres restore issue