Re: Views, views, views! (long)

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)org] On Behalf Of Andrew - Supernews
> Sent: Thursday, May 05, 2005 4:55 PM
> To: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Views, views, views! (long)
>
> 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.

Equally interesting would be:
How many duplicate keys do I have?

An interesting database option might be:
For any foreign key, if there is no existing inversion entry index then
build one.

Another interesting database option might be:
Check the system catalogs for duplicate indexes and remove them if there
are any two completely identical (in columns, asc/desc and type).

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

Obviously, this is a clear oversight by the standards committee.
PostgreSQL is clearly not the only database with this important need.

> --
> 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
majordomo(at)postgresql(dot)org)