AW: [postgis-users] UPDATE_GEOMETRY_STATS() usage ??

[Düster Horst]

correct usage is

select update_geometry_stats('xxdrain','the_geom');
 
Dr. Horst Düster 
GIS-Koordinator /Amtschef Stv.

Kanton Solothurn 
Amt für Geoinformation
Abteilung SO!GIS Koordination
Werkhofstr. 65
CH-4509 Solothurn 

Tel.: ++41 (0)32 627 25 32 
Fax: ++41 (0)32 627 22 14

horst.duester at bd.so.ch 
www.sogis.so.ch



-----Ursprüngliche Nachricht-----
Von: David.Jacques at CCRS.NRCan.gc.ca
[mailto:David.Jacques at CCRS.NRCan.gc.ca]
Gesendet am: Dienstag, 25. Januar 2005 16:18
An: postgis-users at postgis.refractions.net
Betreff: [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
http://postgis.refractions.net/mailman/listinfo/postgis-users