"Rene Gollent" <rgollent(at)asteriasgi(dot)com> writes:
> If you issue a REINDEX DATABASE, which then fails due to db corruption (i.e.
> could not create index due to duplicate values), the resulting error message
> only specifies:
> ERROR: could not create unique index
> DETAIL: Table contains duplicated values.
Hmm. It would be fairly easy to mention the index name here (less so to
mention the table name, but I think you'd really need to know which
index is the problem, anyway). ISTR that when this error message was
written the index *wasn't* known at the place where the message was
being emitted, but we do have it now ...
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2007-10-30 04:09:03|
|Subject: Re: Possible planner bug/regression introduced in 8.2.5 |
|Previous:||From: Rene Gollent||Date: 2007-10-29 19:51:48|
|Subject: BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue|