[SQL] Atomicity of UPDATE, interchanging values in unique column

ACID-compliant? Doesn't MVCC require this anyway? Thanks for your time, Daniel Alvarez <[EMAIL PROTECTED]> -- +++ GMX - Mail, Messaging & more http://www.gmx.net +++ Bitte lächeln! Fotogalerie online mit GMX ohne eigene Homepage!

Re: [SQL] Atomicity of UPDATE, interchanging values in unique column

ots 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 <[EMAIL PROTECTED]> -- +++ GMX