[postgis-devel] [PostGIS] #510: ST_Estimated_Extent doesn't work with views
PostGIS
trac at osgeo.org
Fri Apr 30 12:03:11 PDT 2010
#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
Resolution: | Keywords:
----------------------+-----------------------------------------------------
Comment (by mwtoews):
As a workaround for FDO users that use the PostGIS Provider, you can try
replacing one of the functions:
{{{
CREATE OR REPLACE FUNCTION estimated_extent(text, text, text)
RETURNS box2d AS
$BODY$DECLARE
res box2d;
BEGIN
EXECUTE 'select st_extent(' || quote_ident($3) || ') from ' ||
quote_ident($1) || '.' || quote_ident($2) INTO res;
RETURN res;
END;$BODY$
LANGUAGE 'plpgsql' IMMUTABLE STRICT SECURITY DEFINER
COST 1;
}}}
This workaround has made AutoCAD Map3D 2008 and 2010 more stable (fewer
crashes) when loading layers and generally working with the FDO PostGIS
Provider.
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/510#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-devel
mailing list