On Sun, Jun 27, 2021 at 11:18 AM Allan Kamau <kamauallan(at)gmail(dot)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