<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Ups.<div><br></div><div>The function works on 1.5.3 but not in 2.0SVN</div><div><br></div><div>In 2.0 I get:</div><div><br></div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">ERROR: geometry_estimated_extent: couldn't locate table within current schema</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; min-height: 16px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; min-height: 16px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">********** Error **********</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; min-height: 16px; "><br></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">ERROR: geometry_estimated_extent: couldn't locate table within current schema</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; ">SQL state: XX000</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Monaco; "><br></div>
<br><div><div>On Sep 19, 2011, at 1:06 PM, Paul Ramsey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Javier,<br>You can get a fast, imprecise extent from st_estimated_extent. We<br>should update/change it to use the index top page, but for now it uses<br>the index stats, which means it is sometimes slightly underdetermined,<br>so you might need to grow it by 10-25% depending on your use case.<br>Paul<br><br>On Mon, Sep 19, 2011 at 9:29 AM, Javier de la Torre<br><<a href="mailto:jatorre@vizzuality.com">jatorre@vizzuality.com</a>> wrote:<br><blockquote type="cite">Hi all,<br></blockquote><blockquote type="cite">I need to calculate the extent of a full table. My understanding is that<br></blockquote><blockquote type="cite">this function will do a full scan of the table to calculate it. Is it<br></blockquote><blockquote type="cite">possible to get the extent of the table from the index somehow so that is<br></blockquote><blockquote type="cite">not needed to scan the full table? I also dont need it very precise if that<br></blockquote><blockquote type="cite">helps in any way.<br></blockquote><blockquote type="cite">Thanks!<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Javier de la Torre<br></blockquote><blockquote type="cite">@jatorre<br></blockquote><blockquote type="cite">Vizzuality<br></blockquote><blockquote type="cite">148 Lafayette St. PH, New York, 10013,USA<br></blockquote><blockquote type="cite">Hortaleza 48 1, 28004,Madrid,Spain<br></blockquote><blockquote type="cite">+1 347 320 7715<br></blockquote><blockquote type="cite">+34 689 41 4420<br></blockquote><blockquote type="cite"><a href="http://www.vizzuality.com">www.vizzuality.com</a><br></blockquote><blockquote type="cite">@vizzuality<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite">postgis-users mailing list<br></blockquote><blockquote type="cite"><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br></blockquote><blockquote type="cite"><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>http://postgis.refractions.net/mailman/listinfo/postgis-users<br></div></blockquote></div><br></div></body></html>