Re: safely exchanging primary keys?

On Mon, May 24, 2010 at 02:38:39PM +0000, Tim Landscheidt wrote:
> Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)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.