Opened 6 years ago
Closed 6 years ago
#3976 closed defect (wontfix)
Mark ST_Transform as STABLE
| Reported by: | pramsey | Owned by: | pramsey |
|---|---|---|---|
| Priority: | high | Milestone: | PostGIS 2.5.0 |
| Component: | postgis | Version: | master |
| Keywords: | Cc: |
Description
As @robe noted in #3952, ST_Transform is marked IMMUTABLE, and that it clearly is not, since the underlying spatial_ref_sys table can change at any time. I think "STABLE" is a better description of how it is operationally (safe to cache results in most operational contexts, certainly within a transactional one).
Note:
See TracTickets
for help on using tickets.
Nevermind. It's not possible to build a functional index on a non-IMMUTABLE function, and there's lots of existing ST_Transform() based indexes out there, so changing to STABLE is a non-starter at this point, even if it's "more correct". We've survived this long with it IMMUTABLE, we can survive longer.