[postgis-devel] estimated_extent & pg_statistic

strk at refractions.net strk at refractions.net
Mon Feb 27 08:25:57 PST 2006


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;



More information about the postgis-devel mailing list