[postgis-devel] estimated_extent & pg_statistic

[Martin Schäfer]

But it only needs to know it about tables that are readable by the user. It doesn't need to know it about tables where the user has no read access.
 
What about using the pg_stats view instead of the pg_statistic table?
 
Martin

________________________________

From: postgis-devel-bounces at postgis.refractions.net on behalf of strk at refractions.net
Sent: Wed 22/02/2006 15:24
To: postgis-devel at postgis.refractions.net
Subject: Re: [postgis-devel] estimated_extent & pg_statistic



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       
                                                     
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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



-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 7132 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20060222/ae67b306/attachment.bin>