Re: 回复: pg_restore error with partitioned table having exclude constraint

From: Japin Li <japinli(at)hotmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Keith Paskett <keith(dot)paskett(at)logansw(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: 回复: pg_restore error with partitioned table having exclude constraint
Date: 2026-07-21 10:23:36
Message-ID: SY7PR01MB109217D0D92F80059AC9D5BF4B6C22@SY7PR01MB10921.ausprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, 20 Jul 2026 at 17:34, Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
> On 2025-May-14, Li Japin wrote:
>
>> Apologies for the delay. Considering it further, ignoring ii_ExclusionProcs and
>> ii_ExclusionStrats seems incorrect given custom operators.
>>
>> I've also updated ii_NumIndexAttrs to ii_NumIndexKeyAttrs, as exclusion indexes
>> won't exceed the ii_NumIndexKeyAttrs.
>>
>> I've also moved the test cases to indexing.sql. I'm unsure of its suitability, but seeing
>> pg_dump/pg_upgrade tests prompted the move.
>
> Thanks for updating it. I agree that adding the tests to indexing.sql
> is the right move. I have polished the patch a bit more and pushed to
> branches from 17 onwards.
>

Thanks for pushing the patch.

> --
> Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/

--
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2026-07-21 10:46:44 BUG #19563: Planner does not eliminate redundant outer DISTINCT over UNION
Previous Message Zsolt Parragi 2026-07-21 10:22:53 REPACK (CONCURRENTLY) doesn't handle invalid indexes