Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.200.121\))
Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH
 PARTITION/DETACH PARTITION
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <202411300741.wuc7rpucq72o@alvherre.pgsql>
Date: Sat, 30 Nov 2024 09:44:25 +0100
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general list <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <59310859-2DBA-4075-B834-93E95DF9B2BF@gmail.com>
References: <202411300741.wuc7rpucq72o@alvherre.pgsql>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Archived-At: <https://www.postgresql.org/message-id/59310859-2DBA-4075-B834-93E95DF9B2BF%40gmail.com>
Precedence: bulk

Hi Alvaro,

> On 30 Nov 2024, at 08:41, Alvaro Herrera <alvherre@alvh.no-ip.org> =
wrote:
>=20
> Only if you have self-referencing FKs in partitioned tables.  It
> would be an interesting data point to verify whether this reports
> anything else.  Also, I'd be really curious if your databases include
> the case I'm suspicious about: a multi-level hierarchy containing an =
FK
> that points to an intermediate level of itself.

The instance I reported was the only one in our several hundred =
databases. So I guess this is really a corner case. As mentioned I'll =
try on Monday.

> I'm within fives minutes of longitude and latitude of that location, =
yes
> :-) I didn't want to give unnecessary precision there, but is somebody
> wants to chat sometime or whatever is welcome to ping me.

Then you're not really far way. I'm located in the Solothurn, =
Switzerland area which is only less than 90 km away. Drop me a line if =
you ever make it to Solothurn. =F0=9F=A4=A3

Cheers,
Paul