On 6 Mar 2011, at 9:03, Allan Kamau wrote: > If this is true it seems that the primary key and perhaps other unique > indexes do indeed contain exact details of the uniqueness of the > persisted tuples of a given relation at any given time. That is true within a single transaction, but indexes contain information about ALL active transactions. Because of that the contents of the indexes are not guaranteed to be unique and it's possible they contain references to rows that are not visible to the current transaction. > Or am I missing a crucial point. Yup, you're missing the effects of concurrency. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4d7365c5235885600661482! -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
