Re: [HACKERS] Suggestion: additional system views

2005-06-07 Thread Peter Eisentraut
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

Re: [HACKERS] Suggestion: additional system views

2005-06-06 Thread Josh Berkus
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

Re: [HACKERS] Suggestion: additional system views

2005-06-06 Thread Bruce Momjian
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

Re: [HACKERS] Suggestion: additional system views

2005-06-06 Thread Robert Treat
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

Re: [HACKERS] Suggestion: additional system views

2005-06-06 Thread Bruce Momjian
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

Re: [HACKERS] Suggestion: additional system views

2005-06-04 Thread Bruce Momjian
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:

Re: [HACKERS] Suggestion: additional system views

2004-11-27 Thread Bruce Momjian
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,

Re: [HACKERS] Suggestion: additional system views

2004-10-31 Thread Gaetano Mendola
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

Re: [HACKERS] Suggestion: additional system views

2004-10-31 Thread David Fetter
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

[HACKERS] Suggestion: additional system views

2004-10-28 Thread Josh Berkus
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

Re: [HACKERS] Suggestion: additional system views

2004-10-28 Thread Neil Conway
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

Re: [HACKERS] Suggestion: additional system views

2004-10-28 Thread Josh Berkus
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