diff options
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/intarray/_int.sql.in | 6 | ||||
| -rw-r--r-- | contrib/intarray/uninstall__int.sql | 8 |
2 files changed, 7 insertions, 7 deletions
diff --git a/contrib/intarray/_int.sql.in b/contrib/intarray/_int.sql.in index 37530a9062..44efc85700 100644 --- a/contrib/intarray/_int.sql.in +++ b/contrib/intarray/_int.sql.in @@ -459,9 +459,9 @@ AS --GIN --mark built-in gin's _int4_ops as non default -update pg_opclass set opcdefault = 'f' where - pg_opclass.opcamid = (select pg_am.oid from pg_am where amname='gin') and - opcname = '_int4_ops'; +update pg_catalog.pg_opclass set opcdefault = 'f' +where opcmethod = (select oid from pg_catalog.pg_am where amname='gin') and + opcname = '_int4_ops'; CREATE FUNCTION ginint4_queryextract(internal, internal, int2) RETURNS internal 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'; |