diff options
Diffstat (limited to 'contrib/intarray/uninstall__int.sql')
| -rw-r--r-- | contrib/intarray/uninstall__int.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/contrib/intarray/uninstall__int.sql b/contrib/intarray/uninstall__int.sql index 6f5b863fea..2f3b20fda0 100644 --- a/contrib/intarray/uninstall__int.sql +++ b/contrib/intarray/uninstall__int.sql @@ -124,7 +124,7 @@ DROP FUNCTION querytree(query_int); DROP TYPE query_int CASCADE; -update pg_opclass set opcdefault = 't' where - pg_opclass.opcamid = (select pg_am.oid from pg_am where amname='gin') and - opcname = '_int4_ops'; - +--mark built-in gin's _int4_ops as default again +update pg_catalog.pg_opclass set opcdefault = 't' +where opcmethod = (select oid from pg_catalog.pg_am where amname='gin') and + opcname = '_int4_ops'; |