[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