John Siracusa <siracusa@mindspring.com> writes: > We had a power failure (and a UPS failure) on our database machine. It's > back up now but some spooky stuff is happening. I'm wondering if you are using IDE drives that lie about write completion. You'd never notice until something like this happens. > Is there any way I can "sanity check" the remaining tables for craziness > like this? dump, initdb, reload would be my suggestion. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend