public inbox for [email protected]  

help / color / mirror / Atom feed

From: Paul Foerster <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: pgsql-general list <[email protected]>
Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION
Date: Sat, 30 Nov 2024 09:44:25 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Hi Alvaro,

> On 30 Nov 2024, at 08:41, Alvaro Herrera <[email protected]> wrote:
> 
> 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. 🤣

Cheers,
Paul

view thread (2+ messages)

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox