Craig de Stigter <craig.destig...@koordinates.com> writes: > Somehow we've ended up with a few corrupt indices in our database.
What PG version is this exactly? Do you have any idea how you got into this state? (Database crashes, system crashes, whatever?) We've seen a few similar reports before, but never with enough clarity to identify the bug, if it is a bug. > I'm a bit hesitant to try the fix mentioned at the following URL since it > involves deleting things from system tables: > http://javadave.blogspot.com/2005/06/could-not-open-relation-in-postgresql.html It'd be safer to dump and reload the database. However, given that you already removed the underlying table, I don't see a reason to be terribly concerned about the consistency of the entries about this index. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
