[postgis-tickets] [PostGIS] #4898: ST_SetZ seems to hang indefinitely if a vertex is not in raster

[PostGIS]

#4898: ST_SetZ seems to hang indefinitely if a vertex is not in raster
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 3.2.0
 Component:  postgis  |    Version:  master
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 okay that did not work out well at all, not sure why this didn't work:

 Same hanging issue


 {{{
 NOTICE:  Attempting to get pixel value with out of range raster
 coordinates: (200, 63)
 }}}



 {{{
 SELECT  ST_AsText(
       ST_SetZ(ST_SetBandNoDataValue(k.rast,0),ST_Intersection(t.geom,
 k.rast::geometry)  ) -- <1>
     )
 FROM (SELECT ST_GeomFromText(
                 'LINESTRING(
                     444210 2438785,434125 2448785,
                     466666 2449780,466670 2449781
                 )',
                 26904
         ) AS geom ) AS t
        INNER JOIN ch12.kauai AS k
            ON ST_Intersects(k.rast, t.geom);
 }}}

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