| From: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
|---|---|
| To: | Li Japin <japinli(at)hotmail(dot)com> |
| 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-20 15:34:11 |
| Message-ID: | al49T7fl9EKWEPB_@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2026-07-20 16:10:10 | Re: REINDEX (CONCURRENTLY) TABLE handles DEFERRED constraints as IMMEDIATE while processing |
| Previous Message | PG Bug reporting form | 2026-07-20 09:44:27 | BUG #19560: Wrong results since v16: removable LEFT JOIN silently drops WHERE qual |