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

From Andres Freund
Subject Re: missing toast table for pg_policy
Date
Msg-id 20180216220739.tyrvdpj7qg5xuhbi@alap3.anarazel.de
Whole thread Raw
In response to missing toast table for pg_policy  (Joe Conway <mail@joeconway.com>)
Responses Re: missing toast table for pg_policy  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Hi,

On 2018-02-16 16:56:15 -0500, Joe Conway wrote:
> Looking at the issue, the problem seems to be missing toast table for
> pg_policy. Also attached is a one line patch. It isn't clear to me
> whether this is a candidate for backpatching.

Don't think it is - it'd not take effect on already initdb'ed clusters.

If problematic for < master users I think you'll have to restart cluster
with allow_system_table_mods, manually create/drop toasted column. IIRC
that should add a toast table even after dropping.

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: missing toast table for pg_policy
Next
From: Joe Conway
Date:
Subject: Re: missing toast table for pg_policy