[postgis-tickets] [PostGIS] #3733: Cannot ANALYZE table w/ valid features in it

PostGIS trac at osgeo.org
Fri Jun 23 22:19:21 PDT 2017


#3733: Cannot ANALYZE table w/ valid features in it
----------------------+---------------------------
  Reporter:  pramsey  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.3.3
 Component:  postgis  |    Version:  2.3.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 We can add this to regress tests I guess after you have tested.


 {{{
 CREATE TABLE test_awful(gid serial, geom geometry);
 INSERT INTO test_awful(geom)
 VALUES ( 'POINT ZM (1463702.128 517438.510000008 0
 -1.79769313486232e+308)'::geometry),
  ('POINT ZM (1234886.324 454719.691000004 0
 -1.79769313486232e+308)'::geometry),
  ('POINT ZM (1230629.645 468753.839000007 0
 -1.79769313486232e+308)'::geometry ),
  ('POINT ZM (1243683.988 466816.384999998 0
 -1.79769313486232e+308)'::geometry );

 analyze test_awful;
 }}}


 I assume the notice:


 {{{
 NOTICE:  no non-null/empty features, unable to compute statistics
 }}}
 is what you are referring to.

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


More information about the postgis-tickets mailing list