[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
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 It might be a different thing now.

 I installed postgis-3.0.0alpha3 in my PostgreSQL 12rc1 server.

 Then I installed postgis-3.0.0alpha5dev

 Proceeded to upgrade my 3.0.0alpha3 to 3.0.0alpha5dev


 {{{
 ALTER EXTENSION postgis UPDATE TO "3.0.0alpha5dev";
 }}}

 and to my horror I got this message:


 {{{
 ERROR: could not find function "lwgeom_sortsupport" in file
 "C:/ming64gcc81/projects/postgresql/rel/pg12w64gcc81/lib/postgis-3.dll"
 }}}

 So it's hard to tell if the original problem is fixed as we seem to have a
 new problem.

 I verified that I can do


 {{{
 CREATE EXTENSION postgis VERSION  "3.0.0alpha5dev";
 }}}

 So I'm guess the lwgeom_sortsupport thingy for whatever reason is not
 being included in the upgrade script

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