[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