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

PostGIS trac at osgeo.org
Thu Feb 3 04:32:33 PST 2022


#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
 Keywords:           |
---------------------+---------------------------
 Script based upgrades from 2.5.6 to 3.3.0dev fail with:
 {{{
 sql:/home/src/postgis/postgis/regress/../regress/00-regress-
 install/share/contrib/postgis/postgis_upgrade.sql:9033: ERROR:  window
 function st_clusterkmeans requires an OVER clause
 LINE 1:  SELECT st_clusterkmeans($1,$2)
                 ^
 QUERY:   SELECT st_clusterkmeans($1,$2)
 CONTEXT:  SQL statement "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) $$"
 }}}

 It must be the code handling Replaces comments

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


More information about the postgis-tickets mailing list