[postgis-devel] estimated_extent & pg_statistic

[Chris Hodgson]

I think that pg_stats *should* provide this info, but it doesn't because 
for whatever reason they decided to design it to only work for 
"standard" pg_statistics. Perhaps we need to work with the postgres team 
to get pg_stats to support postgis stat info, or perhaps we need our own 
pg_stats_postgis view which provides the necessary functionality.

Chris

strk at refractions.net wrote:
> On Mon, Feb 27, 2006 at 10:40:35AM -0000, Mark Cave-Ayland wrote:
> 
> 
>>That is correct, you would need to update both versions. I'd like a quick
>>heads up from some of the other developers before committing a fix for this
>>to CVS. In particular, I'm thinking that we may need to add a check to
>>ensure that the session user has been GRANTed read privileges on the
>>specified table before we can return the extents (given that since this
>>function would now be running as a superuser it could potentially allow a
>>user to access information about a table that wouldn't normally be
>>available).
> 
> 
> Adding the check makes sense to me, unless there's a special
> postgresql-provided view only showing stats on columns which are
> user-readable, which would be much better.
> 
> --strk;
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel