Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Поиск
Список
Период
Сортировка
От Paul Foerster
Тема Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION
Дата
Msg-id 59310859-2DBA-4075-B834-93E95DF9B2BF@gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Hi Alvaro,

> On 30 Nov 2024, at 08:41, Alvaro Herrera <alvherre@alvh.no-ip.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
mentionedI'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
mea line if you ever make it to Solothurn. 🤣 

Cheers,
Paul




В списке pgsql-general по дате отправления: