Re: Atomicity of UPDATE, interchanging values in unique

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rod Taylor <rbt(at)rbt(dot)ca>
Cc: daniel alvarez <d-alvarez(at)gmx(dot)de>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Atomicity of UPDATE, interchanging values in unique
Date: 2003-03-08 22:10:44
Message-ID: 12296.1047161444@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

How about swapping all the other columns, and preserving the identity of
the primary key? Arguably, swapping primary keys is a violation of the
relational model to begin with.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message jasiek 2003-03-08 22:27:13 Re: Cancelling Queries
Previous Message Rod Taylor 2003-03-08 21:56:11 Re: Atomicity of UPDATE, interchanging values in unique