| From: | Andrew - Supernews <andrew+nonews(at)supernews(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Views, views, views! (long) |
| Date: | 2005-05-05 23:55:27 |
| Message-ID: | slrnd7lcjf.2ep3.andrew+nonews@trinity.supernews.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2005-05-05, Josh Berkus <josh(at)agliodbs(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2005-05-06 00:14:59 | Re: [pgsql-advocacy] Increased company involvement |
| Previous Message | elein | 2005-05-05 23:54:38 | Re: Views, views, views! (long) |