From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)
Date: Sun, 10 Feb 2019 16:06:29 -0500
Message-ID: <13445.1549832789@sss.pgh.pa.us> (raw)
In-Reply-To: <20190210205449.GA10870@alvherre.pgsql>
References: <20190210205449.GA10870@alvherre.pgsql>
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> On 2019-Feb-10, Peter Geoghegan wrote:
>> On Sun, Feb 10, 2019 at 8:13 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> Just to be be clear, my inclination is to do nothing about this in v11.
>>> It's not apparent to me that any fix is possible given the v11 dependency
>>> data, at least not without downsides that'd likely outweigh the upsides.
>>> We've not seen field complaints about these problems.
>> I thought that you might have had a trick up your sleeve for v11,
>> although I had no idea how that would be possible without making sure
>> that partition dependencies came in pairs to begin with. :-)
> If we disregard the scenario were people downgrade across minor
> versions, it's likely possible to produce SQL queries to transform from
> the old arrangement to the new one, and include those in release notes
> or a wiki page; not for this week's minors (ENOTIME) but maybe for the
> next one.
Dunno ... we couldn't force people to do that, so the server would have to
be prepared to cope with either arrangement, which seems like an
impossible mess.
regards, tom lane
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-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, alvherre@2ndquadrant.com, pg@bowt.ie
Subject: Re: Fixing findDependentObjects()'s dependency on scan order (regressions in DROP diagnostic messages)
In-Reply-To: <13445.1549832789@sss.pgh.pa.us>
* 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