[PostGIS] #5734: Wrong ST_EstimatedExtent result for geography column
PostGIS
trac at osgeo.org
Wed May 22 03:46:02 PDT 2024
#5734: Wrong ST_EstimatedExtent result for geography column
----------------------+---------------------------
Reporter: strk | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 3.4.3
Component: postgis | Version: 3.4.x
Resolution: | Keywords:
----------------------+---------------------------
Comment (by strk):
The index-mediated return is also NULL, even if an index is present:
{{{
strk=# \d qgis_issue_30294
Table "public.qgis_issue_30294"
Column | Type | Collation | Nullable |
Default
--------+-----------------------+-----------+----------+----------------------------------------------
id | integer | | not null |
nextval('qgis_issue_30294_id_seq'::regclass)
g | geography(Point,4326) | | |
Indexes:
"qgis_issue_30294_pkey" PRIMARY KEY, btree (id)
"qgis_issue_30294_g_idx" gist (g)
strk=# select _postgis_index_extent('qgis_issue_30294', 'g');
_postgis_index_extent
-----------------------
(1 row)
}}}
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5734#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