Horton

Re: Potential G2-item cycles under serializable isolation

raf <raf@raf.org>

View thread View on postgr.es
From: raf <raf@raf.org>
To: pgsql-bugs@lists.postgresql.org
Date: 2020-06-12T22:11:36Z
Lists: pgsql-bugs 
Thomas Munro wrote:

> +    Access to the system catalogs is not done using the isolation level
> +    of the current transaction.  This has the effect that newly created
> +    database objects such as tables become visible to concurrent Repeatable
> +    Read and Serializable transactions, even though their contents does not.

"their contents does not" should be "their contents do not".

cheers,
raf

Commits

  1. Doc: Add references for SI and SSI.

  2. Improve comments for [Heap]CheckForSerializableConflictOut().

  3. Avoid update conflict out serialization anomalies.

  4. Implement genuine serializable isolation level.