On Mon, Jul 02, 2007 at 11:46:54AM +0200, Gerhard Hintermayer wrote: > ... x should be y > > I do get these messages one 2 of my servers running mostly on identical > data. The servers are unix-based and are running 8.1.8 under linux (Gentoo). > On one server the message appears only after vacuum-ing, on the other I > had some errors after inserting into the table too (about 12 inserts, no > more messages except while vacuuming since then) Has the server crashed recently? Hash indexes are known not to be crash safe. Using REINDEX on the index should fix it. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature