Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue



The following bug has been logged online:

Bug reference:      3707
Logged by:          Rene Gollent
Email address:      rgollent(at)asteriasgi(dot)com
PostgreSQL version: 8.1.4
Operating system:   Linux (Gentoo)
Description:        failure cases in reindex don't always report enough
information to diagnose the issue
Details: 

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.


without telling you what table actually triggered the error. It *can* be
tracked down by manually looking up the oid of the last table that was
successfully indexed and manually iterating from there, but it'd be nice to
know directly.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group