[postgis-devel] estimated_extent & pg_statistic

[strk at refractions.net]

estimated_extent *needs* to know about minimum and maximum salary :)
Does anybody know if it possilble to have functions run in 'setuid' mode
rather then with permissions derived by caller user ?

--strk;

On Mon, Feb 20, 2006 at 10:10:56AM -0000, Martin Schäfer wrote:
> 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.
>  
>  

> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel


-- 

        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                                                            
      State-collected Geographic Data is public property   
                                                          
                 -*- sign the petition -*-               
                                                        
              http://petition.publicgeodata.org        
                                                      
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~