Re: Atomicity of UPDATE, interchanging values in unique column - Mailing list pgsql-sql

From daniel alvarez
Subject Re: Atomicity of UPDATE, interchanging values in unique column
Date
Msg-id 21780.1047160126@www48.gmx.net
Whole thread Raw
In response to Re: Atomicity of UPDATE, interchanging values in unique column  (Rod Taylor <rbt@rbt.ca>)
Responses Re: Atomicity of UPDATE, interchanging values in unique  (Rod Taylor <rbt@rbt.ca>)
List pgsql-sql
> The first is what you want.  PostgreSQL needs some work in the
> evaluation of unique indexes to properly support it.
> 
> Namely, when it sees a conflict when inserting into the index, it needs
> to record the fact, and revisit the conflict at the end of the command. 
> Lots of work...

OK. The long-term goal would then be to get rid of such oddities. But what
can I do right now as a user to solve that issue for my application?

There must be a better solution than the additional dummy update.

Any ideas?

Daniel Alvarez Arribas <d-alvarez@gmx.de>

-- 
+++ GMX - Mail, Messaging & more  http://www.gmx.net +++
Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!



pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Atomicity of UPDATE, interchanging values in unique column
Next
From: Rod Taylor
Date:
Subject: Re: Atomicity of UPDATE, interchanging values in unique