pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Keith Paskett <keith.paskett@logansw.com>
To: Álvaro Herrera <alvherre@kurilemu.de>
Cc: Japin Li <japinli@hotmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: pg_restore error with partitioned table having exclude constraint
Date: Thu, 17 Apr 2025 13:03:04 -0600
Message-ID: <A57040BA-B461-43DB-B527-047FC68D152D@logansw.com> (raw)
In-Reply-To: <202504171518.tpkk67i7pauh@alvherre.pgsql>
References: <202504171518.tpkk67i7pauh@alvherre.pgsql>

I’m pretty sure that I saw support for exclusion constraints in the PG17 release notes,
and added them to tables that weren’t able to use them in PG16.

They worked great. I just discovered the issue with pg_dump/pg_restore.
The restored tables actually still work because the partition tables have the proper constraint.
Even new partition tables created after the pg_restore get the correct constraint.

Can I assume that the patch will get incorporated into a future release,
and not that exclusion constraints on partition tables will be disallowed?

-Keith


> On Apr 17, 2025, at 9:18 AM, Á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.
> 
> -- 
> Á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/)

view thread (15+ messages)  latest in thread

Message-ID: <A57040BA-B461-43DB-B527-047FC68D152D@logansw.com>
Permalink:  ../A57040BA-B461-43DB-B527-047FC68D152D@logansw.com/
Also on:    postgresql.org/message-id/A57040BA-B461-43DB-B527-047FC68D152D@logansw.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: keith.paskett@logansw.com, alvherre@kurilemu.de, japinli@hotmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: pg_restore error with partitioned table having exclude constraint
  In-Reply-To: <A57040BA-B461-43DB-B527-047FC68D152D@logansw.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox