| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Andrey Klychkov <aaklychkov(at)mail(dot)ru>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: |
| Date: | 2020-06-09 01:36:31 |
| Message-ID: | 20200609013631.GA3326@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2020-06-09 01:59:18 | Re: BUG #16486: Prompted password is ignored when password specified in connection string |
| Previous Message | Peter Geoghegan | 2020-06-09 01:26:01 | Re: Potential G2-item cycles under serializable isolation |