Re: Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix

RNAL EMAIL. STOP. THINK before you CLICK links or OPEN > attachments. > > __ > On Thu, 2023-12-07 at 16:38 -0600, Noel Jones wrote: > > We have been utilizing partitioned tables with indexes. We've recently &g

Invalid Parent Index Issue Will Not Resolve Despite Multiple Attempts To Fix

Hello all, We have been utilizing partitioned tables with indexes. We've recently had an issue where the parent table's index (id, date) became invalid (indisvalid=FALSE, indisready=FALSE in pg_index). For reference the parent table is partitioned on a date field within the table. In order to fin