[postgis-tickets] [PostGIS] #4129: Cannot update SecondarySnapshot during a parallel operation

[PostGIS]

#4129: Cannot update SecondarySnapshot during a parallel operation
---------------------+----------------------------------------
  Reporter:  davidp  |      Owner:  Bborie Park
      Type:  defect  |     Status:  new
  Priority:  high    |  Milestone:  PostGIS 2.4.5
 Component:  raster  |    Version:  2.4.x
Resolution:          |   Keywords:  SecondarySnapshot parallel
---------------------+----------------------------------------

Comment (by Algunenano):

 > So, function marked as parallel safe is executed in parallel mode, even
 if internally calls parallel unsafe function.

 Yes, Postgresql trust the programmer when he declares a function parallel
 but, by definition, any function that calls another one that is parallel
 unsafe should be marked as unsafe too. If you don't, then your unsafe
 function might get called in parallel which leads to errors like this one
 or worse.

 What I meant is, that if `ST_ConverHull` is unsafe (should be reviewed and
 tagged appropriately) then `st_intersects(geom, raster, int)` should be
 marked as unsafe too, but I haven't investigated any further.

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