Zoltan Boszormenyi <zb@xxxxxxxxxxx> writes: > Tom Lane írta: >> What that sounds like to me is a corrupt index (infinite loop of >> right-links, perhaps). Have you tried REINDEXing the table? > How can such an infinite loop sneak into an index? > Hardware is from Sun, not a grocery store PC, so I don't suppose it to > be faulty. > Is there anything in the 8.0.x series that fixes this (or a similar) bug? > If I could point to something in the release notes, I may get them to > upgrade > and they may upgrade to a newer generation even. Well, for instance there's this bug fixed in 8.0.6: http://archives.postgresql.org/pgsql-hackers/2006-01/msg00206.php The discussion there only covers what would happen when the bug manifests on a plain heap relation. I don't think we ever worked out what would happen in an index ... but it seems fairly clear that you would end up with two places linking to the same page, and that might net out to being a loop, depending... In any case, there are enough known bugs in 8.0.3 that I hardly think there needs to be any debate about whether they need to update. regards, tom lane
