[postgis-tickets] [PostGIS] #3750: @ operator not schema qualified in ST_CoveredBy geometry function

PostGIS trac at osgeo.org
Tue May 2 13:47:29 PDT 2017


#3750: @ operator not schema qualified in ST_CoveredBy geometry function
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 2.3.3
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------------
 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)
 }}}

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3750>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list