| From: | Paul Foerster <paul(dot)foerster(at)gmail(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION |
| Date: | 2024-11-30 08:44:25 |
| Message-ID: | 59310859-2DBA-4075-B834-93E95DF9B2BF@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Alvaro,
> On 30 Nov 2024, at 08:41, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Durgamahesh Manne | 2024-11-30 13:18:01 | Regarding logical slots allocation with logical rw |
| Previous Message | Alvaro Herrera | 2024-11-30 07:41:02 | Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION |