Re:How does database indexing work? (2008)
by latch on Tuesday March 08, 2022 @11:13AM
(#30601559)
Less important now, but they're unsafe to use prior to PG 10.
As of 14.1, they still don't support unique constraints:
select amname, pg_indexam_has_property(oid, 'can_unique') from pg_am
amname | pg_indexam_has_property
--------+-------------------------
heap | ¤
btree | t
hash | f
gist | f
gin | f
spgist | f
brin | f
As of 14.1, they still don't support unique constraints: