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

[PostGIS]

#4483: Can't upgrade from PostGIS 3.0.0alpha3 to 3.0.0alpha4 or 3.0.0alpha5dev
(ST_AsGeoJSON)
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  reopened
  Priority:  blocker  |  Milestone:  PostGIS 3.0.1
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 This patch fixes it for me:

 Raul: do you see anything wrong with it ?

 {{{
 diff --git a/postgis/postgis_before_upgrade.sql
 b/postgis/postgis_before_upgrade.sql
 index 0a5f26696..1aacf9168 100644
 --- a/postgis/postgis_before_upgrade.sql
 +++ b/postgis/postgis_before_upgrade.sql
 @@ -57,7 +57,7 @@ BEGIN
                                         WHERE proname =
 'postgis_full_version'
                                         ) AND
                                 LOWER(p.proname) = LOWER(function_name)
 AND
 -
 LOWER(pg_catalog.pg_get_function_arguments(p.oid)) ~
 LOWER(function_arguments) AND
 +
 LOWER(pg_catalog.pg_get_function_identity_arguments(p.oid)) ~
 LOWER(function_arguments) AND
                                 pg_catalog.pg_function_is_visible(p.oid)
                         ORDER BY 1, 2, 4
         LOOP
 }}}

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