Re: safely exchanging primary keys? - Mailing list pgsql-sql

On Mon, May 24, 2010 at 02:38:39PM +0000, Tim Landscheidt wrote:
> Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org> wrote:
> 
> What does "are not properly updated" mean? Anyhow, why don't

Hi,

I did follow-up on my own post: the problem was elsewhere.

> you use something simple like (untested):
> 
> | UPDATE cabin_type
> |   SET id_cabin_type =
> |     CASE
> |       WHEN id_cabin_type = id1 THEN
> |         id2
> |       ELSE
> |         id1
> |     END
> |   WHERE id_cabin_type IN (id1, id2);

Nice, thanks.