Re: BUG #12330: ACID is broken for unique constraints - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #12330: ACID is broken for unique constraints
Date
Msg-id 31456.1419608483@sss.pgh.pa.us
Whole thread Raw
In response to BUG #12330: ACID is broken for unique constraints  (nikita.y.volkov@mail.ru)
List pgsql-bugs
nikita.y.volkov@mail.ru writes:
> Executing concurrent transactions inserting the same value of a unique key
> fails with the "duplicate key" error under code "23505" instead of any of
> transaction conflict errors with a "40***" code.

Sounds fine to me, in fact preferable to a 40XXX code.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12344: libcurses issue with psql binary of Solaris package
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #12324: database's age less then max(relAGE) , and stream standby diff with master