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

From Álvaro Herrera
Subject Re: pg_restore error with partitioned table having exclude constraint
Date
Msg-id 202504171518.tpkk67i7pauh@alvherre.pgsql
Whole thread Raw
In response to Re: pg_restore error with partitioned table having exclude constraint  (Japin Li <japinli@hotmail.com>)
Responses Re: pg_restore error with partitioned table having exclude constraint
List pgsql-bugs
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.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"On the other flipper, one wrong move and we're Fatal Exceptions"
(T.U.X.: Term Unit X  - http://www.thelinuxreview.com/TUX/)



pgsql-bugs by date:

Previous
From: Japin Li
Date:
Subject: Re: pg_restore error with partitioned table having exclude constraint
Next
From: Keith Paskett
Date:
Subject: Re: pg_restore error with partitioned table having exclude constraint