See REINDEX. But my point was that there may be undetected corruption.If I were you I'd not rely on REINDEX to prevent all problems.
Indeed; REINDEX neither detected nor fixed the corruption.
Thanks for all your help; we'll recreate the database as soon as we can.
Many thanks,
Chris Purcell
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
