The following bug has been logged online:
Bug reference: 1502
Logged by: Thomas
Email address: thhal(at)mailblocks(dot)com
PostgreSQL version: 8.0.1
Operating system: N/A
Description: hash_seq_search might return removed entry
Details:
The hash_seq_search keeps track of what element that it should return next
in a HASH_SEQ_STATUS struct when it peruses a bucket. Removing that element
from the table won't change anything since the struct remains unaffected. It
still holds onto that element and hence, will return it on next iteration.