contrib/btree_gin/sql/install_btree_gin.sql


1
2
3
4
5
6

CREATE EXTENSION btree_gin;

-- Check whether any of our opclasses fail amvalidate
SELECT amname, opcname
FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid);