Re: [RFC] Removing "magic" oids - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [RFC] Removing "magic" oids
Date
Msg-id 20181027185656.2jiit4epdpk46dlh@alap3.anarazel.de
Whole thread Raw
In response to Re: [RFC] Removing "magic" oids  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [RFC] Removing "magic" oids  (Amit Kapila <amit.kapila16@gmail.com>)
List 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 by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [RFC] Removing "magic" oids
Next
From: Narayanan V
Date:
Subject: Re: Postgres restore issue