Re: [HACKERS] postgresql transactons not fully isolated - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: [HACKERS] postgresql transactons not fully isolated
Date
Msg-id 30f0e35d-c91c-ecfa-edc5-9f5c2f8a14ff@anastigmatix.net
Whole thread Raw
In response to [HACKERS] postgresql transactons not fully isolated  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: [HACKERS] postgresql transactons not fully isolated  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
On 06/20/2017 03:08 PM, Chapman Flack wrote:

> For me (in PG 9.5 at $work), at the instant of the commit in T1,
> T2 says:
> ERROR:  could not serialize access due to concurrent update

I get that result in 'serializable' and in 'repeatable read'.

I get the reported result (DELETE 0 and a table containing 2 and 3)
in both 'read committed' and 'read uncommitted'.

-Chap



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Something is rotten in publication drop
Next
From: "David G. Johnston"
Date:
Subject: Re: [HACKERS] postgresql transactons not fully isolated