Thread: Suggestion: additional system views

Suggestion: additional system views

From
Josh Berkus
Date:
Folks,

Is there any reason that we don't have pg_functions, pg_users, pg_groups and 
other system views?    pg_tables and pg_views is really useful, but it would 
be good to cover the other items as well.

Is there a reason not to have these other than that they're not coded?   If 
not, I'll get working on them.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco


Re: Suggestion: additional system views

From
Neil Conway
Date:
On Fri, 2004-10-29 at 07:35, Josh Berkus wrote:
> Is there any reason that we don't have pg_functions, pg_users, pg_groups and 
> other system views?    pg_tables and pg_views is really useful, but it would 
> be good to cover the other items as well.

pg_functions might be useful, but what would pg_users offer that pg_user
does not already do?

A pg_sequences view might also be handy.

-Neil




Re: Suggestion: additional system views

From
Josh Berkus
Date:
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.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


Re: Suggestion: additional system views

From
Gaetano Mendola
Date:
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.


Regards
Gaetano Mendola




Re: Suggestion: additional system views

From
David Fetter
Date:
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@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

Attachment

Re: Suggestion: additional system views

From
Bruce Momjian
Date:
This has been saved for the 8.1 release:
http:/momjian.postgresql.org/cgi-bin/pgpatches2

---------------------------------------------------------------------------

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@fetter.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@postgresql.org)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Suggestion: additional system views

From
Bruce Momjian
Date:
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@fetter.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@postgresql.org)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Suggestion: additional system views

From
Josh Berkus
Date:
Bruce,

> I do like this idea.  Can you make a general patch?  Do others like the
> idea of system tables showing error codes and keywords?

Yes.  However, I think the idea of additional system views has already been 
shot down in flames.   

Unless people think that it's reasonable to have a system view for error codes 
and not one for, say, operators?  

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


Re: Suggestion: additional system views

From
Bruce Momjian
Date:
Josh Berkus wrote:
> Bruce,
> 
> > I do like this idea.  Can you make a general patch?  Do others like the
> > idea of system tables showing error codes and keywords?
> 
> Yes.  However, I think the idea of additional system views has already been 
> shot down in flames.   

> Unless people think that it's reasonable to have a system view for error codes 
> and not one for, say, operators?  

Uh, I thought the shoot-down was for duplication of existing information
in new system tables, not the addition of new system table information,
e.g. we have pg_operator, but no list of error codes or keywords in the
system tables.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Suggestion: additional system views

From
Robert Treat
Date:
On Monday 06 June 2005 17:35, Bruce Momjian wrote:
> Josh Berkus wrote:
> > Bruce,
> >
> > > I do like this idea.  Can you make a general patch?  Do others like the
> > > idea of system tables showing error codes and keywords?
> >
> > Yes.  However, I think the idea of additional system views has already
> > been shot down in flames.
> >
> > Unless people think that it's reasonable to have a system view for error
> > codes and not one for, say, operators?
>
> Uh, I thought the shoot-down was for duplication of existing information
> in new system tables, not the addition of new system table information,
> e.g. we have pg_operator, but no list of error codes or keywords in the
> system tables.

Would this include a new view for showing user priviliges, rather than the 
current method of incense and chanting that are needed to divine the meaning 
of pg_class.relacl ?

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


Re: Suggestion: additional system views

From
Bruce Momjian
Date:
Robert Treat wrote:
> On Monday 06 June 2005 17:35, Bruce Momjian wrote:
> > Josh Berkus wrote:
> > > Bruce,
> > >
> > > > I do like this idea.  Can you make a general patch?  Do others like the
> > > > idea of system tables showing error codes and keywords?
> > >
> > > Yes.  However, I think the idea of additional system views has already
> > > been shot down in flames.
> > >
> > > Unless people think that it's reasonable to have a system view for error
> > > codes and not one for, say, operators?
> >
> > Uh, I thought the shoot-down was for duplication of existing information
> > in new system tables, not the addition of new system table information,
> > e.g. we have pg_operator, but no list of error codes or keywords in the
> > system tables.
> 
> Would this include a new view for showing user priviliges, rather than the 
> current method of incense and chanting that are needed to divine the meaning 
> of pg_class.relacl ?

The new tables have to do with error messages and keywords.  It has
nothing to do with permissions.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Suggestion: additional system views

From
Peter Eisentraut
Date:
Bruce Momjian wrote:
> Uh, I thought the shoot-down was for duplication of existing
> information in new system tables, not the addition of new system
> table information, e.g. we have pg_operator, but no list of error
> codes or keywords in the system tables.

System tables are primarily useful if (a) the information is variable 
for a given installation, or (b) client programs may want to 
automatically process the information.  Neither seems to apply here.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/