Re: missing toast table for pg_policy - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: missing toast table for pg_policy
Date
Msg-id 20180718040127.GJ2998@paquier.xyz
Whole thread Raw
In response to Re: missing toast table for pg_policy  (Michael Paquier <michael@paquier.xyz>)
Responses Re: missing toast table for pg_policy  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Tue, Jul 17, 2018 at 06:03:26PM +0900, Michael Paquier wrote:
> On Tue, Jul 17, 2018 at 02:55:07PM +0700, John Naylor wrote:
>> I didn't dig deeper, since TOAST and the large object facility are
>> mutually exclusive so there shouldn't be a toast table here anyway.
>> Hope this helps.
>
> [... digging ...]
> This comes from get_rel_infos where large objects are treated as user
> data.  Rather than the comment you added, I would rather do the
> following:
> "Large object catalogs and toast tables are mutually exclusive and large
> object data is handled as user data by pg_upgrade, which would cause
> failures."

So, I have been playing with the previous patch and tortured it through
a couple of upgrade scenarios, where it proves to work.  Attached is an
updated patch which adds toast tables except for pg_class, pg_attribute,
pg_index and pg_largeobject* with a proposal of commit message.  Any
objections for the commit of this stuff?
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: ENOSPC FailedAssertion("!(RefCountErrors == 0)"
Next
From: Amit Khandekar
Date:
Subject: Re: AtEOXact_ApplyLauncher() and subtransactions