[postgis-users] UPDATE_GEOMETRY_STATS() usage ??
David.Jacques at CCRS.NRCan.gc.ca
David.Jacques at CCRS.NRCan.gc.ca
Tue Jan 25 07:18:07 PST 2005
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.
More information about the postgis-users
mailing list