set-level update fails with unique constraint violation

Поиск
Список
Период
Сортировка
От neuhauser+pgsql-general#postgresql.org@sigpipe.cz
Тема set-level update fails with unique constraint violation
Дата
Msg-id 20091231095220.GA1484@isis.sigpipe.cz
обсуждение исходный текст
Ответы Re: set-level update fails with unique constraint violation
Re: set-level update fails with unique constraint violation
Re: set-level update fails with unique constraint violation
Список pgsql-general
Hello,

this fails with "duplicate key value":

    CREATE TABLE x (
      i INT NOT NULL UNIQUE
    );
    INSERT INTO x (i) VALUES (1), (2), (3);
    UPDATE x SET i = i + 1;

are there any plans to make this work?

--
Roman Neuhauser

В списке pgsql-general по дате отправления: