[postgis-tickets] [PostGIS] #4661: ST_Distance(geography, geography) fails when schema name contains hyphen character

PostGIS trac at osgeo.org
Thu Apr 9 10:02:15 PDT 2020


#4661: ST_Distance(geography, geography) fails when schema name contains hyphen
character
-------------------------+---------------------
  Reporter:  kunszabo67  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:
 Component:  postgis     |    Version:  2.5.x
Resolution:              |   Keywords:
-------------------------+---------------------

Comment (by Algunenano):

 I've fixed it in the core extension by storing the full qualified table
 name in POSTGIS_CONSTANTS and using it wherever it's needed.

 I've checked raster SPI_execute calls and found several issues
 (`_st_summarystats` being called directly without schema, and the same for
 `spatial_ref_sys`) but the code, specially around mapalgebra is far from
 clear. Not only that, but the internal types in the SQL code aren't
 qualified either, so there is quite a bit to do if you want to really run
 raster in a different schema and support FDW. I'm just going to open a
 different issue to track for whoever is interested on the feature to
 handle.

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