From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-05 00:38:40 |
Message-ID: | 200506050038.j550ceR01397@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I do like this idea. Can you make a general patch? Do others like the
idea of system tables showing error codes and keywords?
---------------------------------------------------------------------------
David Fetter wrote:
> On Mon, Nov 01, 2004 at 12:49:47AM +0100, Gaetano Mendola wrote:
> > Josh Berkus wrote:
> > >Neil,
> > >
> > >
> > >>pg_functions might be useful, but what would pg_users offer that pg_user
> > >>does not already do?
> > >
> > >
> > >Show a list of groups that the user belongs to? Same thing with
> > >pg_groups; showing the list of users in the group.
> > >
> > >
> > >>A pg_sequences view might also be handy.
> > >
> > >
> > >Yes. Anything else? So far I have:
> > >
> > >pg_users
> > >pg_groups
> > >pg_functions
> > >pg_sequences
> > >hmmm ...
> > >pg_schemas
> > >pg_tablespaces
> > >... as well, just for completeness.
> > >
> > >This is obviously and 8.1 thing, so I'll put it on my task list for after
> > >8.0 PR is done.
> >
> > I suggest to add on pg_functions and on pg_views too, the list of
> > dependencies with other objects.
>
> pg_keywords
> pg_sqlstates
>
> Attached is a rough draft of the latter.
>
> Cheers,
> D
> --
> David Fetter david(at)fetter(dot)org http://fetter.org/
> phone: +1 510 893 6100 mobile: +1 415 235 3778
>
> Remember to vote!
[ Attachment, skipping... ]
>
> ---------------------------(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)
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-06-05 00:45:57 | Re: Two-phase commit |
Previous Message | Bruce Momjian | 2005-06-05 00:36:52 | Re: [PATCHES] WAL bypass for CTAS |