Re: serializable transaction: exclude constraint violation (backed by GIST index) instead of ssi conflict

2019-04-11 Thread Peter Billen
On Thu, Apr 11, 2019 at 6:12 PM Peter Billen wrote: > > I believe we are after multiple issues/improvements: > > 1. Could we extend > https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=fcff8a575198478023ada8a48e13b50f70054766 > by adding support for exclude const

Re: serializable transaction: exclude constraint violation (backed by GIST index) instead of ssi conflict

2019-04-11 Thread Peter Billen
On Thu, Apr 11, 2019 at 1:14 AM Thomas Munro wrote: > On Thu, Apr 11, 2019 at 10:54 AM Thomas Munro > wrote: > > On Thu, Apr 11, 2019 at 9:43 AM Peter Billen > wrote: > > > I kinda expected/hoped that transaction t2 would get aborted by a > serialization error, an

serializable transaction: exclude constraint violation (backed by GIST index) instead of ssi conflict

2019-04-10 Thread Peter Billen
Hi all, I understood that v11 includes predicate locking for gist indexes, as per https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=3ad55863e9392bff73377911ebbf9760027ed405 . I tried this in combination with an exclude constraint as following: drop table if exists t; create table t(