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

PostGIS trac at osgeo.org
Thu Apr 9 06:27:24 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):

 Something like https://github.com/postgis/postgis/pull/553 should fix it

 With that patch:
 {{{
 schematest=# create database schema2;
 CREATE DATABASE
 schematest=# \c schema2
 You are now connected to database "schema2" as user "postgres".
 schema2=#  SET search_path TO public;
 SET
 schema2=#  CREATE SCHEMA "schema-with-hyphen";
 CREATE SCHEMA
 schema2=#  CREATE EXTENSION postgis WITH SCHEMA "schema-with-hyphen";
 CREATE EXTENSION
 schema2=#  SET search_path TO public, "schema-with-hyphen";
 SET
 schema2=#  SELECT 'POINT (1 1)'::geography, 'POINT (1 2)'::geography;
                      geography                      |
 geography
 ----------------------------------------------------+----------------------------------------------------
  0101000020E6100000000000000000F03F000000000000F03F |
 0101000020E6100000000000000000F03F0000000000000040
 (1 row)

 schema2=#  SELECT ST_DISTANCE('POINT (1 1)'::geography, 'POINT (1
 2)'::geography);
    st_distance
 -----------------
  110575.06481434
 (1 row)
 }}}

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