[GENERAL] serialization failure why?

I have these 2 tables: CREATE TABLE "stuff" ("number" integer NOT NULL PRIMARY KEY, "title" varchar(40) NOT NULL); CREATE TABLE "stuff_ext" ("stuff_ptr_id" integer NOT NULL PRIMARY KEY, "extra" integer NOT NULL); ALTER TABLE "stuff_ext" ADD CONSTRAINT "stuff_ext_stuff_ptr_id_5a4ee8edae53404b"

Re: [GENERAL] serialization failure why?

On Tue, 16 Jun 2015 13:33:12 +0001 Filipe Pina wrote: > I have these 2 tables: > > CREATE TABLE "stuff" ("number" integer NOT NULL PRIMARY KEY, "title" > varchar(40) NOT NULL); > CREATE TABLE "stuff_ext" ("stuff_ptr_id" integer NOT NULL PRIMARY KEY, > "extra" integer NOT NULL); > ALTER TABLE "

Re: [GENERAL] serialization failure why?

Indeed Bill, if drop the foreign key constraint on stuff_ext table there are no failures at all... But, since I can't remove the foreign key, how can I tell postgres that he can "trust" it then? Because it's obvious (for the code reader at least), that the other transaction will not be respons

Re: [GENERAL] serialization failure why?

Filipe Pina wrote: > if drop the foreign key constraint on stuff_ext table there are > no failures at all… It is my recollection that we were excluding the queries used to enforce referential integrity constraints from the conflict tracking, so I am surprised you are seeing this. What is the ex

Re: [GENERAL] serialization failure why?

Hi Kevin, I have installed: PostgreSQL 9.3.7 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit But as you mentioned it should have been fixed in later versions, I've upgraded to 9.4: PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2

Re: [GENERAL] serialization failure why?

Indeed Bill, if drop the foreign key constraint on stuff_ext table I get 0 failures... But, since I can't remove the foreign key, how can I tell postgres that he can "trust" it then? Because it's obvious (for the code reader at least), that the other transaction will not be responsible for cre

Re: [GENERAL] serialization failure why?

Kevin, assuming you will have some time to confirm that it has been fixed in some version some time next week, I’ve compiled the test steps in http://pastebin.com/4Uqc2kPv Thanks once again > On 17/06/2015, at 14:40, Filipe Pina wrote: > > Hi Kevin, > > I have

Re: [GENERAL] serialization failure why?

On 17 June 2015 at 13:52, Kevin Grittner wrote: > Filipe Pina wrote: > > > if drop the foreign key constraint on stuff_ext table there are > > no failures at all… > > It is my recollection that we were excluding the queries used to > enforce referential integrity constraints from the conflict >

Re: [GENERAL] serialization failure why?

Simon Riggs wrote: > On 17 June 2015 at 13:52, Kevin Grittner wrote: >> Filipe Pina wrote: >>> if drop the foreign key constraint on stuff_ext table there are >>> no failures at all… >> >> It is my recollection that we were excluding the queries used to >> enforce referential integrity constrai

Re: [GENERAL] serialization failure why?

On 29 June 2015 at 21:13, Kevin Grittner wrote: > Simon Riggs wrote: > > On 17 June 2015 at 13:52, Kevin Grittner wrote: > >> Filipe Pina wrote: > > >>> if drop the foreign key constraint on stuff_ext table there are > >>> no failures at all… > >> > >> It is my recollection that we were exclud