blob: ce4559d8b03fdcf00367f0fabfe08e03367c9dd7 (
plain)
1
2
3
4
5
6
7
8
9
|
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);
amname | opcname
--------+---------
(0 rows)
|