[postgis-tickets] [PostGIS] #5080: script based upgrade from 2.5.6 fails: ERROR: window function st_clusterkmeans requires an OVER clause

[PostGIS]

#5080: script based upgrade from 2.5.6 fails: ERROR:  window function
st_clusterkmeans requires an OVER clause
----------------------+---------------------------
  Reporter:  strk     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.3.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by strk):

 When upgraded via EXTENSION mechanism, the wrapper function GETS created
 but is non-functioning at runtime:
 {{{
 postgis_reg=# select st_clusterkmeans_deprecated_by_postgis_302(g1, 1)
 over () from upgrade_test;
 ERROR:  window function st_clusterkmeans requires an OVER clause
 LINE 1:  SELECT st_clusterkmeans($1,$2)
                 ^
 QUERY:   SELECT st_clusterkmeans($1,$2)
 CONTEXT:  SQL function "st_clusterkmeans_deprecated_by_postgis_302" during
 startup
 }}}

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