summaryrefslogtreecommitdiff
path: root/contrib/hstore/sql/hstore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/hstore/sql/hstore.sql')
-rw-r--r--contrib/hstore/sql/hstore.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/hstore/sql/hstore.sql b/contrib/hstore/sql/hstore.sql
index 48514789e64..d64b9f77c75 100644
--- a/contrib/hstore/sql/hstore.sql
+++ b/contrib/hstore/sql/hstore.sql
@@ -1,5 +1,10 @@
CREATE EXTENSION hstore;
+-- 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);
+
set escape_string_warning=off;
--hstore;