[postgis-tickets] [PostGIS] #4608: Geography GIST index fails on ST_Covers (table named test) (was: Geography GIST index fails on table named test)

PostGIS trac at osgeo.org
Wed Dec 25 17:32:47 PST 2019


#4608: Geography GIST index fails on ST_Covers (table named test)
----------------------+---------------------------
  Reporter:  jgh      |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  low      |  Milestone:  PostGIS 3.1.0
 Component:  postgis  |    Version:  3.0.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 Okay I don't think this has anything to do with the table name.

 I have the same issue with any geography table I have when using
 ST_Covers.

 Just tried on my airports table


 {{{
 SELECT * from ch09.airports WHERE ST_Covers(geog,
 ST_GeogFromText('POINT(-0.1 51.5)'));
 }}}

 and get error


 {{{
 ERROR:  no spatial operator found for opfamily 51535 strategy 7
 SQL state: XX000
 }}}


 But replacing with ST_Intersects works.  So I think it's our ST_Covers
 operator stuff needs some loving.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4608#comment:2>
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