Re: pg_restore error with partitioned table having exclude constraint - Mailing list pgsql-bugs

From Japin Li
Subject Re: pg_restore error with partitioned table having exclude constraint
Date
Msg-id ME0P300MB04459912DFAA3BEC7215C0BEB6852@ME0P300MB0445.AUSP300.PROD.OUTLOOK.COM
Whole thread Raw
In response to Re: pg_restore error with partitioned table having exclude constraint  (Álvaro Herrera <alvherre@kurilemu.de>)
Responses Re: pg_restore error with partitioned table having exclude constraint
List pgsql-bugs
On Thu, 17 Apr 2025 at 17:18, Álvaro Herrera <alvherre@kurilemu.de> wrote:
> On 2025-Apr-17, Japin Li wrote:
>
>> It seems PG 16 does not support exclusion constraints on partitioned tables.
>
> Yeah, my recollection is that they were purposefully disallowed (mainly
> because I didn't want to research how to fully make them work when
> adding local partitioned indexes), and that we needed to do more work if
> we wanted to let them through.  I suspect commit 8c852ba9a4 was mistaken
> to allow that case without looking for further implications.
>

Sorry, I’m unclear on “more work.” Can you explain further?

--
Regrads,
Japin Li



pgsql-bugs by date:

Previous
From: Tender Wang
Date:
Subject: Re: BUG #18902: TRAP:: failed Assert("!is_sorted") in File: "createplan.c"
Next
From: Michael Paquier
Date:
Subject: Re: BUG #18893: Segfault during analyze pg_database