[postgis-tickets] [PostGIS] #4299: st_generatepoints declared IMMUTABLE

[PostGIS]

#4299: st_generatepoints declared IMMUTABLE
---------------------+---------------------
 Reporter:  pnorman  |      Owner:  pramsey
     Type:  defect   |     Status:  new
 Priority:  medium   |  Milestone:
Component:  postgis  |    Version:  2.3.x
 Keywords:           |
---------------------+---------------------
 On my 2.3 system `st_generatepoints` is declared as `IMMUTABLE`. This is
 only valid for functions that always generate the same output given the
 same parameters. Random functions should be VOLATILE because they can give
 different results each time they are called.

 On a closely related matter, it is also marked as `PARALLEL SAFE`, which
 might not be true - https://www.postgresql.org/docs/11/parallel-
 safety.html says that `random` is `PARALLEL RESTRICTED` because it
 accesses "miscellaneous backend-local state which the system cannot
 synchronize across workers" and the same might be true for
 st_generatepoints

 This originates from https://lists.osgeo.org/pipermail/postgis-
 devel/attachments/20190115/292e0a64/attachment.html

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