[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-devel
Subject:    Re: [postgis-devel] [PostGIS] #510: ST_Estimated_Extent doesn't
From:       "PostGIS" <trac () osgeo ! org>
Date:       2010-04-30 19:03:11
Message-ID: 058.bb62a550f240117b59a9d680d5804c7d () osgeo ! org
[Download RAW message or body]

#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 &amp; task tracking, a user and \
developer wiki, and a view into the subversion code repository of PostGIS project. \
_______________________________________________ postgis-devel mailing list
postgis-devel@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-devel


[prev in list] [next in list] [prev in thread] [next in thread]