News for hackers. Stuff that matters.
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

There are no comments on this comment yet.