Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation
Date
Msg-id CACjxUsNKtNVhX6EoxY9FjS7N1aJ=inopGT0EqV_yKF6oup0p_g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation  (Kevin Grittner <kgrittn@gmail.com>)
Responses Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-hackers
Tree view 
On Mon, Dec 12, 2016 at 12:32 PM, Kevin Grittner <kgrittn@gmail.com> wrote:

> As you can see, this generated a serialization failure.

That was on 9.6.  On earlier versions it does indeed allow the
transaction on connection 2 to commit, yielding a non-serializable
result.  This makes a pretty strong case for back-patching this
commit:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=fcff8a575198478023ada8a48e13b50f70054766

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Typo in doc/src/sgml/catalogs.sgml
Next
From: Peter Geoghegan
Date:
Subject: Re: [HACKERS] tuplesort_gettuple_common() and *should_free argument