SERIALIZABLE and INSERTs with multiple VALUES

Поиск
Список
Период
Сортировка
От Jason Dusek
Тема SERIALIZABLE and INSERTs with multiple VALUES
Дата
Msg-id CAO3NbwOycQjt2Oqy2VW-eLTq2M5uGMyHnGm=RNga4mjqcYD7gQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: SERIALIZABLE and INSERTs with multiple VALUES
Список pgsql-general

Hi All,

I notice the following oddity:

 =# CREATE TABLE with_pk (i integer PRIMARY KEY);
CREATE TABLE
=# BEGIN;
BEGIN=# INSERT INTO with_pk VALUES (1) ON CONFLICT DO NOTHING;
INSERT 0 1=# INSERT INTO with_pk VALUES (1) ON CONFLICT DO NOTHING;
INSERT 0 0=# END;
COMMIT
=# BEGIN;
BEGIN=# INSERT INTO with_pk VALUES (2), (2) ON CONFLICT DO NOTHING;
ERROR:  could not serialize access due to concurrent update=# END;
ROLLBACK

How are these two transactions different?

Kind Regards,

  Jason Dusek

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