<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML DIR=ltr><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"></HEAD><BODY><DIV><FONT face="Courier New" color=#000000 size=2>Strk,</FONT></DIV>
<DIV><FONT face="Courier New" color=#000000 size=2></FONT> </DIV>
<DIV><FONT face="Courier New" color=#000000 size=2>The function estimated_extent
seems to make use of the pg_statistic system table. But the PostgreSQL
documentation says:</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>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.) </FONT><TT class=STRUCTNAME><FONT color=#000000
size=2>pg_stats</FONT></TT><FONT face="Courier New" size=2> is a publicly
readable view on pg_statistic that only exposes information about those tables
that are readable by the current user.</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>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?</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV><FONT face="Courier New" size=2>Martin Schaefer</FONT></DIV>
<DIV><FONT face="Courier New" size=2>Cadcorp Ltd.</FONT></DIV>
<DIV><FONT face="Courier New" size=2></FONT> </DIV>
<DIV> </DIV></BODY></HTML>