[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):

 Enabling warnings in the upgrade script shows that ALTER EXTENSION UPDATE
 does enter the block attempting to rewrite the function in SQL but for
 some reason that block does not end up raising an exception:
 {{{
 WARNING:  Handling deprecated function
 st_clusterkmeans_deprecated_by_postgis_302(geometry,integer)
 WARNING:  SQL: CREATE OR REPLACE FUNCTION
 public.st_clusterkmeans_deprecated_by_postgis_302(geom geometry, k
 integer)
  RETURNS integer
  LANGUAGE sql
  WINDOW STRICT
 AS $$ SELECT st_clusterkmeans($1,$2) $$
 }}}

 If I try the command manually I do get the exception. There must be some
 special environment during extension upgrade/creation that prevents the
 exception from being thrown.

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