Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Is there anything stopping us going through the code and finding all > ereports that can be fixed by a REINDEX, and issue a HINT with all of > them saying that they should REINDEX the broken index?
How would you know which ones correspond to REINDEX-fixable conditions? I generally dislike hints that tell people their first action should be to destroy the evidence, anyway. If they had an index problem, REINDEX will guarantee there is no chance of learning anything about it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org