From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Michael Paquier <michael@paquier.xyz>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: exclusion@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16577: Segfault on altering a table located in a dropped tablespace
Date: Wed, 28 Oct 2020 10:40:45 -0300
Message-ID: <20201028134045.GA6709@alvherre.pgsql> (raw)
In-Reply-To: <20201028051821.GI28445@paquier.xyz>
On 2020-Oct-28, Michael Paquier wrote:
> On Thu, Oct 15, 2020 at 12:19:59PM -0300, Alvaro Herrera wrote:
> > It just dawned on me that a way to fix this is to use a pg_shdepend
> > entry to protect the tablespace from being dropped.
>
> Haven't thought of that approach, good idea! That would not be
> backpatchable but that would be a solution that does not require
> creating files where we don't need them. Did you begin to look at
> that?
I haven't started on this one yet, but I intend to do so shortly.
Strictly speaking, we can still introduce a new category of pg_shdepend
entries in back branches; it won't break anything that works today. And
while it won't fix the problem on existing partitioned tables, it is
possible to have users run a query on each database to create any rows
needed. The only *actual* incompatibility is that once you upgrade and
create the rows, an older server of the same major may misbehave when
does rows are present. But do we ever see users going back to previous
minors? I think this isn't really a terrible problem in practice. And
even if it is, users can work around it by deleting the offending rows.
What do you think?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, michael@paquier.xyz, tomas.vondra@2ndquadrant.com, tgl@sss.pgh.pa.us, exclusion@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16577: Segfault on altering a table located in a dropped tablespace
In-Reply-To: <20201028134045.GA6709@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox