[postgis-tickets] [PostGIS] #4359: FAIL: upgrade 2.5.0--3.0.0dev: function st_distance(geography, geography) is not unique

[PostGIS]

#4359: FAIL: upgrade 2.5.0--3.0.0dev: function st_distance(geography, geography)
is not unique
------------------------------------+---------------------------
  Reporter:  strk                   |      Owner:  strk
      Type:  defect                 |     Status:  new
  Priority:  blocker                |  Milestone:  PostGIS 3.0.0
 Component:  build/upgrade/install  |    Version:  trunk
Resolution:                         |   Keywords:
------------------------------------+---------------------------

Comment (by strk):

 In the postgis_reg database:
 {{{
 -[ RECORD 1
 ]------+-------------------------------------------------------------------------------------------------------------------
 pg_get_functiondef | CREATE OR REPLACE FUNCTION
 public.st_distance(geography, geography)
 +
                    |  RETURNS double precision
 +
                    |  LANGUAGE sql
 +
                    |  IMMUTABLE PARALLEL SAFE STRICT
 +
                    | AS $function$SELECT public._ST_Distance($1, $2, 0.0,
 true)$function$                                              +
                    |
 -[ RECORD 2
 ]------+-------------------------------------------------------------------------------------------------------------------
 pg_get_functiondef | CREATE OR REPLACE FUNCTION public.st_distance(geom1
 geometry, geom2 geometry)                                     +
                    |  RETURNS double precision
 +
                    |  LANGUAGE c
 +
                    |  IMMUTABLE PARALLEL SAFE STRICT COST 10
 +
                    | AS '$libdir/postgis-3',
 $function$ST_Distance$function$
 +
                    |
 -[ RECORD 3
 ]------+-------------------------------------------------------------------------------------------------------------------
 pg_get_functiondef | CREATE OR REPLACE FUNCTION public.st_distance(geog1
 geography, geog2 geography, use_spheroid boolean DEFAULT true)+
                    |  RETURNS double precision
 +
                    |  LANGUAGE c
 +
                    |  IMMUTABLE PARALLEL SAFE STRICT COST 10
 +
                    | AS '$libdir/postgis-3',
 $function$geography_distance$function$
 +
                    |
 -[ RECORD 4
 ]------+-------------------------------------------------------------------------------------------------------------------
 pg_get_functiondef | CREATE OR REPLACE FUNCTION public.st_distance(text,
 text)                                                         +
                    |  RETURNS double precision
 +
                    |  LANGUAGE sql
 +
                    |  IMMUTABLE PARALLEL SAFE STRICT
 +
                    | AS $function$ SELECT
 public.ST_Distance($1::public.geometry, $2::public.geometry);  $function$
 +
                    |
 }}}

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