On 2005-05-05, Josh Berkus <josh@agliodbs.com> wrote:
> And, as Lance points out, these system views would help as a diagnostic view
> for support engineers. Actually, I'll second that; I've had cause to
> recommend the CVS system views more than a dozen times to pgsql newbies on
> IRC. For example, there is an easy query you can do using the new system
> views (thanks, Andrew!) to check what unindexed foriegn keys you have.
Another popular query that gets asked on IRC is "how do I find out what
permissions have been granted to user X?" Try doing _that_ one in the
system catalogs.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services