summaryrefslogtreecommitdiffstats
path: root/contrib/btree_gist/sql/init.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--contrib/btree_gist/sql/init.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/contrib/btree_gist/sql/init.sql b/contrib/btree_gist/sql/init.sql
new file mode 100644
index 0000000..a6d2cff
--- /dev/null
+++ b/contrib/btree_gist/sql/init.sql
@@ -0,0 +1,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);