From 5b0d9da27ad2edab02624ca67ccf429dd14186e8 Mon Sep 17 00:00:00 2001 From: Markus Schaber Date: Wed, 20 Apr 2005 15:09:53 +0000 Subject: [PATCH] Fixed pg_opclass update to be schema-aware. git-svn-id: http://svn.osgeo.org/postgis/trunk@1657 b70326c6-7e19-0410-871a-916f4a2858ee --- lwgeom/lwpostgis.sql.in | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/lwgeom/lwpostgis.sql.in b/lwgeom/lwpostgis.sql.in index bb176752d..8c1f82228 100644 --- a/lwgeom/lwpostgis.sql.in +++ b/lwgeom/lwpostgis.sql.in @@ -825,8 +825,13 @@ CREATE OPERATOR CLASS gist_geometry_ops FUNCTION 7 LWGEOM_gist_same (box2d, box2d, internal); UPDATE pg_opclass - SET opckeytype = (select oid from pg_type where typname = 'box2d') - WHERE opcname = 'gist_geometry_ops'; + SET opckeytype = (SELECT oid FROM pg_type + WHERE typname = 'box2d' + AND typnamespace = (SELECT oid FROM pg_namespace + WHERE nspname=current_schema())) + WHERE opcname = 'gist_geometry_ops' + AND opcnamespace = (SELECT oid from pg_namespace + WHERE nspname=current_schema()); -- TODO: add btree binding... -- 2.50.0