aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dunstan <andrew@dunslane.net>2013-09-30 11:33:54 -0400
committerAndrew Dunstan <andrew@dunslane.net>2013-09-30 11:38:31 -0400
commitd794eae6135b3bb43b54498e95253aa43d776905 (patch)
treec1f6515dceedb1bd2ced74fcf2542f1389e72ebd
parent7f165f2587f6dafe7d4d438136dd959ed5610979 (diff)
downloadpostgresql-d794eae6135b3bb43b54498e95253aa43d776905.tar.gz
postgresql-d794eae6135b3bb43b54498e95253aa43d776905.zip
Add missing condition for pg_depend in hstore migration script.
Error noted by Andres Freund.
-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 99b8a168fa3..9c127d44033 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