Re: [GENERAL] A contradiction in 13.2.1

2016-01-27 Thread Dane Foster
On Wed, Jan 27, 2016 at 5:59 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jan 27, 2016 at 3:23 PM, Dane Foster wrote: > >> Hello, >> >> I'm trying to understand concurrency in PostgreSQL so I'm slowly reading >> through chapter 13 of the fine manual and I believe I've foun

Re: [GENERAL] A contradiction in 13.2.1

2016-01-27 Thread David G. Johnston
On Wed, Jan 27, 2016 at 3:23 PM, Dane Foster wrote: > Hello, > > I'm trying to understand concurrency in PostgreSQL so I'm slowly reading > through chapter 13 of the fine manual and I believe I've found a > contradiction in section 13.2.1. > > ​My understanding of the second sentence of the first

Re: [GENERAL] A contradiction in 13.2.1

2016-01-27 Thread Hannes Erven
Dane, > So the mental model I've built based on the first four sentences of > the first paragraph is that when a transaction starts in read > committed mode a snapshot is taken of the (database) universe as it > exists at the moment of its creation and that it's only updated by > changes made by

[GENERAL] A contradiction in 13.2.1

2016-01-27 Thread Dane Foster
Hello, I'm trying to understand concurrency in PostgreSQL so I'm slowly reading through chapter 13 of the fine manual and I believe I've found a contradiction in section 13.2.1. ​My understanding of the second sentence of the first paragraph is that read committed mode never sees "changes committ