summaryrefslogtreecommitdiff
path: root/contrib
diff options
context:
space:
mode:
authorAndrew Dunstan2013-09-30 15:33:54 +0000
committerAndrew Dunstan2013-09-30 15:38:31 +0000
commitd794eae6135b3bb43b54498e95253aa43d776905 (patch)
treec1f6515dceedb1bd2ced74fcf2542f1389e72ebd /contrib
parent7f165f2587f6dafe7d4d438136dd959ed5610979 (diff)
Add missing condition for pg_depend in hstore migration script.
Error noted by Andres Freund.
Diffstat (limited to 'contrib')
-rw-r--r--contrib/hstore/hstore--1.1--1.2.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/contrib/hstore/hstore--1.1--1.2.sql b/contrib/hstore/hstore--1.1--1.2.sql
index 99b8a168fa..9c127d4403 100644
--- a/contrib/hstore/hstore--1.1--1.2.sql
+++ b/contrib/hstore/hstore--1.1--1.2.sql
@@ -18,6 +18,7 @@ BEGIN
FROM pg_proc p
JOIN pg_depend d
ON p.proname = 'hstore_to_json_loose'
+ AND d.classid = 'pg_proc'::regclass
AND d.objid = p.oid
AND d.refclassid = 'pg_extension'::regclass
JOIN pg_extension x