[postgis-devel] estimated_extent & pg_statistic

strk at refractions.net strk at refractions.net
Mon Mar 6 03:56:48 PST 2006


On Mon, Feb 27, 2006 at 05:37:45PM -0000, Mark Cave-Ayland wrote:

> Perhaps we should consider adding a new postgis_stats() view to solve the
> problem, and then tweak estimate_extent() to use that instead? A \d pg_stats
> shows that the has_table_privilege() function should do the job fairly
> easily.

I'd rather avoid adding another view.
What about using has_table_privilege() from withing a SECURITY DEFINER ?
Also, can CREATE OR REPLACE FUNCTION override the SECURITY DEFINER specifier ?
--strk;



More information about the postgis-devel mailing list