[postgis-tickets] [PostGIS] #4464: PostGIS 2.5 not regressing cleanly in PostgreSQL 9.4

[PostGIS]

#4464: PostGIS 2.5 not regressing cleanly in PostgreSQL 9.4
----------------------+---------------------------
  Reporter:  robe     |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  blocker  |  Milestone:  PostGIS 2.5.3
 Component:  postgis  |    Version:  2.5.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by pramsey):

 Yuh, I get the same effect, it looks like 9.4 has slightly different
 behaviour from 9.5 in terms of how it executes things like
 {{{
 select '#877.3',
   round(st_xmin(e.e)::numeric, 5), round(st_xmax(e.e)::numeric, 5),
   round(st_ymin(e.e)::numeric, 5), round(st_ymax(e.e)::numeric, 5)
 from ( select ST_EstimatedExtent('t','g') as e ) e;
 }}}
 9.4 manages to execute it, running `ST_EstimatedExtent` just once, while
 9.5/9.6/10/11/12 run it four times (and gets four notices as a result).
 I'm not sure what we do except excise those tests, we cannot unfortunately
 use the MATERIALIZE keyword in the older versions to force 12 to have the
 same behaviour as the older ones.

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