[postgis-tickets] [PostGIS] #4483: Can't upgrade from PostGIS 3.0.0alpha3 to 3.0.0alpha4 ST_AsGeoJSON

[PostGIS]

#4483: Can't upgrade from PostGIS 3.0.0alpha3 to 3.0.0alpha4 ST_AsGeoJSON
---------------------+---------------------------
 Reporter:  robe     |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  blocker  |  Milestone:  PostGIS 3.0.0
Component:  postgis  |    Version:  trunk
 Keywords:           |
---------------------+---------------------------
 {{{
 CREATE EXTENSION postgis VERSION "3.0.0alpha3";
 ALTER EXTENSION postgis UPDATE;
 }}}

 Get error -- velix mentioned this in IRC -
 {{{
 ERROR:  cannot change name of input parameter "pretty_print"
 HINT:  Use DROP FUNCTION st_asgeojson(record,text,integer,boolean) first.
 }}}

 it apppears someone decided to rename the last param and did not add the
 necessary drop logic;

 To work around the issue I had to do:


 {{{
 ALTER EXTENSION postgis DROP FUNCTION
 st_asgeojson(record,text,integer,boolean);

 DROP FUNCTION st_asgeojson(record,text,integer,boolean);

 }}}

 Then


 {{{
 ALTER EXTENSION postgis UPDATE;
 }}}

 works.  strk I thought our upgrade tests are supposed to catch these no?

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