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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
