diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2013-09-30 11:33:54 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2013-09-30 11:33:54 -0400 |
| commit | 7ce569babddf7bc76657390032cb6cf6793476cc (patch) | |
| tree | 0dc42c6e695869a1c42721e0c8b7f7080abf30b5 | |
| parent | eebdea08bb6c185dd7e7542f35565a2c12ab1342 (diff) | |
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.sql | 1 |
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 |