From: | Heikki Rauhala <heikki(dot)rauhala(at)reaktor(dot)fi> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | Miko Kiiski <miko(dot)kiiski(at)reaktor(dot)com> |
Subject: | "insert [...] on conflict" hangs on conflict on an unmentioned gist index |
Date: | 2016-07-04 12:10:32 |
Message-ID: | 4C976D6B-76B4-434C-8052-D009F7B7AEDA@reaktor.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 =)
);
insert into gist_test (bar, foo) values ('bar', 'foo');
insert into gist_test (bar, foo) values ('baz', 'foo’) 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.
From | Date | Subject | |
---|---|---|---|
Next Message | nqtien310 | 2016-07-04 13:43:38 | BUG #14226: pg_upgrade for 8.4 to 9.4 failed |
Previous Message | Michael Paquier | 2016-07-04 05:20:23 | Re: BUG #14225: Password reset does not work. |