Re: pg_restore error with partitioned table having exclude constraint

Japin Li <japinli@hotmail.com>

From: Japin Li <japinli@hotmail.com>

To: Álvaro Herrera <alvherre@kurilemu.de>

Cc: Keith Paskett <keith.paskett@logansw.com>, pgsql-bugs@lists.postgresql.org

Date: 2025-04-24T15:07:53Z

Lists: 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Allow some exclusion constraints on partitions
- 8c852ba9a434 17.0 cited
Local partitioned indexes
- 8b08f7d4820f 11.0 cited