On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau <kamaual...@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." https://www.postgresql.org/docs/current/btree-gin.html