Suggestion: additional system views
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
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
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
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
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!
Attachments:
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_sqlstatesAttached 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 3778Remember 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, Pennsylvania 19073I 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_sqlstatesAttached 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 3778Remember 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, Pennsylvania 19073Bruce,
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
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, Pennsylvania 19073
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
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, Pennsylvania 19073
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/