[postgis-tickets] [PostGIS] #5313: ST_Collect + ST_InterpolateRaster = "Unknown geometry type"

[PostGIS]

#5313: ST_Collect + ST_InterpolateRaster = "Unknown geometry type"
------------------------+---------------------------
  Reporter:  Player701  |      Owner:  pramsey
      Type:  defect     |     Status:  new
  Priority:  high       |  Milestone:  PostGIS 3.3.3
 Component:  postgis    |    Version:  3.3.x
Resolution:             |   Keywords:
------------------------+---------------------------
Comment (by pramsey):

 I'm not 100% sure this is an ST_InterpolateRaster problem... it certainly
 does nothing special with its inputs, nothing different from other
 functions, and this seems very much an "input memory disappears" problem.

 What PgSQL version are you on? I see the same thing, but this is the kind
 of thing that might change over PgSQL versions.

 This works, for example.
 {{{
 SELECT ST_InterpolateRaster(
   pts,
   'invdist',
   ST_AddBand(ST_MakeEmptyRaster(1, 1, 0, 0, 1), '32BF')
 )
 FROM (SELECT ST_Collect(pt) AS pts
     FROM (
     SELECT 'POINT Z(3729230.119184725 5657111.610875956
 273.3486328125)'::geometry AS pt
     UNION SELECT 'POINT Z(3757059.9918830437 5657111.610875956
 273.0422668457031)'::geometry AS pt
     ) pts) cpts;
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5313#comment:1>
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.