1CREATE EXTENSION btree_gist;
2-- Check whether any of our opclasses fail amvalidate
3SELECT amname, opcname
4FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
5WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid);
6 amname | opcname
7--------+---------
8(0 rows)
9
10