Re: - Mailing list pgsql-bugs

From Michael Paquier
Subject Re:
Date
Msg-id 20200609013631.GA3326@paquier.xyz
Whole thread Raw
In response to Re:  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
On Mon, Jun 08, 2020 at 01:37:07PM -0400, Alvaro Herrera wrote:
> I think this part remains unanswered: why are there *three* invalid
> indexes, and not two?  It makes sense for the UNIQUE indexes to acquire
> invalid duplicates, but strangely we also have a
> act_re_procdef_deployment_id_idx_ccnew which is *not* unique.  What
> happened there?

More than one REINDEX query at table-level failed I guess?

> (I also wonder if it wouldn't make more sense to reindexdb to attempt to
> drop indexes that it couldn't complete.)

(That's a good idea.)
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Potential G2-item cycles under serializable isolation
Next
From: Tom Lane
Date:
Subject: Re: BUG #16486: Prompted password is ignored when password specified in connection string