[postgis-tickets] [PostGIS] #5348: Non-extension based dump-restore tests failing on new ST_ClusterIntersectingWin

PostGIS trac at osgeo.org
Sun Feb 26 20:43:04 PST 2023


#5348: Non-extension based dump-restore tests failing on new
ST_ClusterIntersectingWin
-----------------------------------+---------------------------
 Reporter:  robe                   |      Owner:  strk
     Type:  defect                 |     Status:  new
 Priority:  medium                 |  Milestone:  PostGIS 3.4.0
Component:  build/upgrade/install  |    Version:  master
 Keywords:                         |
-----------------------------------+---------------------------
 The new functions on https://github.com/postgis/postgis/pull/721

 are triggering failure

 when running


 {{{
 make check RUNTESTFLAGS="-v --dumprestore"
 }}}

 errors with:


 {{{
 ERROR:  function "st_clusterintersectingwin" already exists with same
 argument types
 }}}

 So I presume postgis_restore.pl is not filtering this function out for
 some reason.


 But work fine with

 {{{
 make check RUNTESTFLAGS="-v --extension--dumprestore"
 }}}


 I'm not seeing anything wrong with the availability checks in it.

 I thought maybe postgis_restore.pl is not handling window functions, but
 if that is the case it should have chocked also on ST_ClusterDBScan and
 ST_ClusterKMeans.

 Whatever the issue is I figure we can fix after its commited.

 I'm changing cirrus to test against extension based install, which I think
 is more useful too  because all fixes that would be done using schema
 quals I assume will only be fixed in extension based dump/restore
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5348>
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