PolarDB-for-PostgreSQL
6 строк · 219.0 Байт
1CREATE EXTENSION btree_gin;
2
3-- Check whether any of our opclasses fail amvalidate
4SELECT amname, opcname
5FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
6WHERE opc.oid >= 16384 AND NOT amvalidate(opc.oid);
7