Re: [HACKERS] BUG #12330: ACID is broken for unique constraints

I'll repost my (OP) case, for the references to it to make more sense to the others. Having the following table: CREATE TABLE "song_artist" ( "song_id" INT8 NOT NULL, "artist_id" INT8 NOT NULL, PRIMARY KEY ("song_id", "artist_id") ); Even trying to protect from this wit

Re: [HACKERS] BUG #12330: ACID is broken for unique constraints

nce. Again, they should be returned as > sparsely as possible because they provide absolutely (as Tom pointed > out) zero detail to the application. The precise definition of the > error is up to us, but I'd rather keep it to it's current rather > specific semantics. >

Re: [HACKERS] BUG #12330: ACID is broken for unique constraints

I believe, the objections expressed in this thread miss a very important point of all this: the isolation property (the "I" in ACID) is violated. Here’s a quote from the Wikipedia article on ACID : The isolation property ensures that the concurrent execution of