[postgis-tickets] [PostGIS] #2489: st_asgml functions not dropped 2.0 to 2.1 upgrade

[PostGIS]

#2489: st_asgml functions not dropped 2.0 to 2.1 upgrade
-----------------------+----------------------------------------------------
 Reporter:  kyngchaos  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.1.1
Component:  postgis    |     Version:  2.1.x        
 Keywords:             |  
-----------------------+----------------------------------------------------
Changes (by erictheise):

 * cc: erictheise (added)


Comment:

 I'm also affected by this defect. In trying to upgrade from postgresql 9.2
 to 9.3, I updated postgis from 2.0.3 to 2.1.0, but the migration is not
 smooth. In my pg_upgrade_dump_N.custom file, I'm seeing (sorry for the
 binary artifacts):

 ALTER EXTENSION "postgis" ADD FUNCTION "_st_asgeojson"(integer,
 "geometry", integer, integer);
 ^@O^@^@^@DROP FUNCTION "public"."_st_asgeojson"(integer, "geometry",
 integer, integer);
 ^A^A^@^@^@^@^F^@^@^@public^A^A^@^@^@^@^H^@^@^@postgres^@^E^@^@^@false^@^C^@^@^@191^@^A^@^@^@5^@^D^@^@^@1890^A^A^@^@^@^C^@^@^@^@^@^@^@^@^@"^A^@^@^@^@^@^@^@^@^D^@^@^@1255^@^F^@^@^@144795^@9^@^@^@_st_asgml(integer,
 "geography", integer, integer,
 "text")^@^H^@^@^@FUNCTION^@^B^@^@^@^@¨^@^@^@CREATE FUNCTION
 "_st_asgml"(integer, "geography", integer, integer, "text") RETURNS "text"
     LANGUAGE "c" IMMUTABLE
     AS '$libdir/'''postgis-2.0'''', 'geography_as_gml';
 ^@T^@^@^@DROP FUNCTION "public"."_st_asgml"(integer, "geography", integer,
 integer, "text");
 ^A^A^@^@^@^@^F^@^@^@public^A^A^@^@^@^@^H^@^@^@postgres^@^E^@^@^@false^@^A^@^@^@5^@^D^@^@^@1924^A^A^@^@^@^C^@^@^@^@^@^@^@^@^@
 ^A^@^@^@^@^@^@^@^@^D^@^@^@1255^@^F^@^@^@144614^@8^@^@^@_st_asgml(integer,
 "geometry", integer, integer,
 "text")^@^H^@^@^@FUNCTION^@^B^@^@^@^@£^@^@^@CREATE FUNCTION
 "_st_asgml"(integer, "geometry", integer, integer, "text") RETURNS "text"
     LANGUAGE "c" IMMUTABLE
     AS '$libdir/'''postgis-2.0'''', 'LWGEOM_asGML';
 ^@S^@^@^@DROP FUNCTION "public"."_st_asgml"(integer, "geometry", integer,
 integer, "text");
 ^A^A^@^@^@^@^F^@^@^@public^A^A^@^@^@^@^H^@^@^@postgres^@^E^@^@^@false^@^D^@^@^@1890^@^A^@^@^@5^A^A^@^@^@^C^@^@^@^@^@^@^@^@^@Ô^C^@^@^@^@^@^@^@^@^D^@^@^@1255^@^F^@^@^@830579^@A^@^@^@_st_asgml(integer,
 "geography", integer, integer, "text",
 "text")^@^H^@^@^@FUNCTION^@^B^@^@^@^@]^A^@^@CREATE FUNCTION
 "_st_asgml"(integer, "geography", integer, integer, "text", "text")
 RETURNS "text"
     LANGUAGE "c" IMMUTABLE
     AS '$libdir/postgis-2.1', 'geography_as_gml';

 when everything else refers to postgis-2.1. As a consequence, my
 loadable_libraries.txt file includes this error:

 Could not load library "$libdir/postgis-2.0"
 ERROR:  could not access file "$libdir/postgis-2.0": No such file or
 directory

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