[postgis-devel] estimated_extent & pg_statistic
Martin Schäfer
Martin.Schaefer at cadcorp.com
Mon Feb 20 02:10:56 PST 2006
Strk,
The function estimated_extent seems to make use of the pg_statistic system table. But the PostgreSQL documentation says:
pg_statistic should not be readable by the public, since even statistical information about a table's contents may be considered sensitive. (Example: minimum and maximum values of a salary column might be quite interesting.) pg_stats is a publicly readable view on pg_statistic that only exposes information about those tables that are readable by the current user.
So in many installations the pg_statistic table will be unavailable, making estimated_extent unavailable as well. Is it possible to change estimated_extent to use the pg_stats view instead of the pg_statistic table?
Martin Schaefer
Cadcorp Ltd.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060220/e5062de0/attachment.html>
More information about the postgis-devel
mailing list