John Siracusa <siracusa(at)mindspring(dot)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