"insert [...] on conflict" hangs on conflict on an unmentioned gist index

Поиск
Список
Период
Сортировка
От Heikki Rauhala
Тема "insert [...] on conflict" hangs on conflict on an unmentioned gist index
Дата
Msg-id 4C976D6B-76B4-434C-8052-D009F7B7AEDA@reaktor.fi
обсуждение исходный текст
Ответы Re: "insert [...] on conflict" hangs on conflict on an unmentioned gist index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hi,

The last insert of the following statements causes a busy loop that does =
not complete:

create table gist_test (
  bar text,
  foo text,
  constraint gist_test_bar_unique unique (bar),
  constraint gist_test_foo_gist_unique exclude using gist (foo with =3D)
);
insert into gist_test (bar, foo) values ('bar', 'foo');
insert into gist_test (bar, foo) values ('baz', 'foo=E2=80=99) on =
conflict on constraint gist_test_bar_unique do nothing;

Expected behaviour is a conflict on the gist_test_foo_gist_unique =
-index.

The issue is present at least in the following PostgreSQL versions:

PostgreSQL 9.5.3 on x86_64-apple-darwin15.4.0, compiled by Apple LLVM =
version 7.3.0 (clang-703.0.31), 64-bit
PostgreSQL 9.5.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 =
20120313 (Red Hat 4.4.7-16), 64-bit

Best regards,

- Heikki Rauhala.=

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14225: Password reset does not work.
Следующее
От: rob.nieuwenhuizen@mobpro.com
Дата:
Сообщение: BUG #14227: Former master not shot down