Opened 7 years ago

Closed 7 years ago

#3750 closed defect (fixed)

@ and ~ operators not always schema qualified in geometry and raster functions

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 2.3.3
Component: postgis Version: 2.3.x
Keywords: Cc:

Description

Error reported on PostGIS mailing list: https://lists.osgeo.org/pipermail/postgis-users/2017-May/042090.html

Was a solution to this problem ever discovered? I'm running into exactly the same problem (backup from PostGIS 2.1 with raster tables can't be restored to PostGIS 2.3).

HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
QUERY:  SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)
CONTEXT:  SQL function "st_coveredby" during inlining
COPY coei_166_3857, line 1: "1  010000010091C9D81F26AAE94091C9D81F26AAE9C082B6A532F81B73C103DAD0FE58846041000000000000000000000000..."
pg_restore: [archiver (db)] Error from TOC entry 187538; 0 223203 TABLE DATA coei_196_3857 asdf
pg_restore: [archiver (db)] COPY failed for table "coei_196_3857": ERROR:  operator does not exist: public.geometry @ public.geometry
LINE 1: SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)

Attachments (1)

postgis3750.patch (1.4 KB ) - added by srstclair 7 years ago.

Download all attachments as: .zip

Change History (6)

comment:1 by robe, 7 years ago

Owner: changed from pramsey to robe

by srstclair, 7 years ago

Attachment: postgis3750.patch added

comment:2 by srstclair, 7 years ago

The attached patch fixed the remaining offenders (I believe).

comment:3 by robe, 7 years ago

In 15382:

@ operator not schema qualified and ~ not schema qualified in some places
apply patch with adjustments. Patch provided by Shane StClair (Axiom Data Science)
References #3750 for trunk PostGIS 2.4.0

comment:4 by robe, 7 years ago

Summary: @ operator not schema qualified in ST_CoveredBy geometry function@ and ~ operators not always schema qualified in geometry and raster functions

comment:5 by robe, 7 years ago

Resolution: fixed
Status: newclosed

In 15383:

@ operator not schema qualified and ~ not schema qualified in some places
apply patch with adjustments. Patch provided by Shane StClair (Axiom Data Science)
Closes #3750 for PostGIS 2.3.3

Note: See TracTickets for help on using tickets.