The following bug has been logged online: Bug reference: 1502 Logged by: Thomas Email address: [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq