What PG version is this exactly? Do you have any idea how you got into this state?
Using PostgreSQL 8.3.7-0ubuntu8.10.1 from the Intrepid repository.
version() is PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.2-1ubuntu11) 4.3.2
No database crashes or system restarts were involved. We accidentally had two transactions open which were writing new rows to the table and then creating the same indices. One failed with a 'could not open relation with OID X' error and the other continued but failed for some unrelated reason. When we dropped the table and tried to recreate the table we noticed the indices were still there.
I don't see a reason to beterribly concerned about the consistency of the entries about this index.
The only issue is that we do want to be able to create that table again...
Thanks a bunch
Craig de Stigter -- Koordinates Ltd PO Box 1604, Shortland St, Auckland, New Zealand Phone +64-9-966 0433 Fax +64-9-969 0045 Web http://www.koordinates.com
