Re: BUG #12330: ACID is broken for unique constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nikita(dot)y(dot)volkov(at)mail(dot)ru
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12330: ACID is broken for unique constraints
Date: 2014-12-26 15:41:23
Message-ID: 31456.1419608483@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

nikita(dot)y(dot)volkov(at)mail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Marko Tiikkaja 2014-12-26 15:44:25 Re: BUG #12330: ACID is broken for unique constraints
Previous Message Tom Lane 2014-12-26 15:39:52 Re: BUG #12344: libcurses issue with psql binary of Solaris package

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2014-12-26 15:44:25 Re: BUG #12330: ACID is broken for unique constraints
Previous Message Tom Lane 2014-12-26 15:32:00 Re: Some other odd buildfarm failures