[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