Home > mailing lists

Re: GIN indexed unique constraint? - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: GIN indexed unique constraint?
Date	June 27, 2021 21:28:31
Msg-id	CAKFQuwYZ1TgtN0KRxbFxJofDQub93ay9SmHPNV3t1rP45xGy1w@mail.gmail.com Whole thread Raw
In response to	GIN indexed unique constraint? (Allan Kamau <kamauallan@gmail.com>)
Responses	Re: GIN indexed unique constraint? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau <kamauallan@gmail.com> wrote:

Is it possible to declare a UNIQUE constraint that uses GIN indexing?

Doesn't seem to be possible. The btree_gin extension would provide the necessary code but it states explicitly that:

"... and they lack one major feature of the standard B-tree code: the ability to enforce uniqueness."

From: Allan Kamau
Date: 27 June 2021, 21:18:30
Subject: GIN indexed unique constraint?

From: Tom Lane
Date: 27 June 2021, 21:41:09
Subject: Re: GIN indexed unique constraint?