contrib/btree_gist/sql/init.sql


1
2
3
4
5
6

CREATE EXTENSION btree_gist;

-- 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);