[postgis-users] update_geometry_stats() on PostGIS 0.8.1

[strk at refractions.net]

On Fri, Jan 28, 2005 at 06:09:31PM +0100, Markus Schaber wrote:
> Hello,
> 
> On some of our PostGIS 0.8.1 databases, update_geometry_stats() fails:
> 
> logigis=# select update_geometry_stats();
> ERROR:  more than one row returned by a subquery used as an expression
> CONTEXT:  PL/pgSQL function "update_geometry_stats" line 2 at execute
> statement
> 
> I think this could be caused by some problems wr/t schemas (we have
> several equally named tables in different schemas).
> 
> I did not yet look at the code, but do you think it is possible to fix
> this function (or replace it with a fixed function from a never PostGIS)?
> 
> I would like to avoid updating the whole PostGIS.

It is surely updatable.
Get the one you have in 1.0.0.
Of course you'll have to build lwpostgis.sql with USE_VERSION=<your_pg_ver>.
Pre 800 stats computation and use is not changed.

--strk;

> 
> Thanks,
> Markus
> -- 
> markus schaber | dipl. informatiker
> logi-track ag | rennweg 14-16 | ch 8001 zürich
> phone +41-43-888 62 52 | fax +41-43-888 62 53
> mailto:schabios at logi-track.com | www.logi-track.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users