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

[robe]

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)

[srstclair]

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

[robe]

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

[robe]

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