[postgis-users] UPDATE_GEOMETRY_STATS() usage ??

Gregory S. Williamson gsw at globexplorer.com
Tue Jan 25 14:34:49 PST 2005

Try single quoting the parameters being passed into the procedure, e.g.:
select * from update_geometry_stats('xxdrain','the_geom');


Greg Williamson
GlobeXplorer LLC

-----Original Message-----
From:	David.Jacques at CCRS.NRCan.gc.ca [mailto:David.Jacques at CCRS.NRCan.gc.ca]
Sent:	Tue 1/25/2005 7:18 AM
To:	postgis-users at postgis.refractions.net
Subject:	[postgis-users] UPDATE_GEOMETRY_STATS() usage ??
As per section 3.4 of the FAQ for speeding up queries &
Display of large spatial tables I have created indexes on them using

CREATE INDEX [indexname] ON [tablename] USING GIS ( [geometrycolumn]);

However running this: SELECT UPDATE_GEOMETRY_STATS(xxdrain,the_geom); gives
 an error telling me that column "xxdrain" doesn't exist. 

I've looked in the  function list and this function is overloaded, 
1 form with 2 varchar params and one with only 1 (column name expected). 
However running what this other form expects also gives an error.

Any examples of a successful run of this to ensure my spatial indexes and 
Statistics are up to date would be great.

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list