Re: Transaction isolation and table contraints

2020-11-25 Thread David G. Johnston
On Wed, Nov 25, 2020 at 8:14 AM Konstantin Knizhnik < k.knizh...@postgrespro.ru> wrote: > Hi hackers, > > I wonder if it is considered as correct behavior that transaction > conflict detection depends on presence of primary key: > > create table t(pk integer, val integer); > insert into t values (

Transaction isolation and table contraints

2020-11-25 Thread Konstantin Knizhnik
Hi hackers, I wonder if it is considered as correct behavior that transaction conflict detection depends on presence of primary key: create table t(pk integer, val integer); insert into t values (1,0),(2,0); Session1: begin isolation level serializable; Session2: begin isolation level seriali