| 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.
| 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 |