[postgis-devel] [PostGIS] #510: ST_Estimated_Extent doesn't work with views

[PostGIS]

#510: ST_Estimated_Extent doesn't work with views
---------------------+------------------------------------------------------
 Reporter:  mwtoews  |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.5.2
Component:  postgis  |     Version:  1.5.X        
 Keywords:           |  
---------------------+------------------------------------------------------
 If a GIS-enabled view is set up with metadata in the geometry_columns
 table, the ST_Estimated_Extent command throws an error:
 {{{
 select st_estimated_extent('public','myview','the_geom');
 ERROR: LWGEOM_estimated_extent: couldn't locate table within current
 schema
 SQL state: XX000
 }}}
 even though the relation exists:
 {{{
 SELECT count(*)=1
 FROM pg_catalog.pg_namespace nm
 JOIN pg_catalog.pg_class c ON nm.oid=c.relnamespace
 JOIN pg_catalog.pg_attribute a ON c.oid=a.attrelid
 WHERE nm.nspname='public' AND c.relname='myview' AND attname='the_geom'
 }}}

 This error appears to affect the FDO PostGIS Provider, since I see this
 error in the logs near crashes in AutoCAD Map 3D.

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