BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue
От
Rene Gollent
Тема
BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue
Дата
Msg-id
200710291951.l9TJpmgo083445@wwwmaster.postgresql.org
Список
Дерево обсуждения
BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue "Rene Gollent" <rgollent@asteriasgi.com>
Re: BUG #3707: failure cases in reindex don't always report enough information to diagnose the issue Tom Lane <tgl@sss.pgh.pa.us>
The following bug has been logged online: Bug reference: 3707 Logged by: Rene Gollent Email address: rgollent@asteriasgi.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.
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата: