Lists: | pgsql-hackers |
---|
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Suggestion: additional system views |
Date: | 2004-10-28 21:35:16 |
Message-ID: | 200410281435.16116.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Neil Conway <neilc(at)samurai(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Suggestion: additional system views |
Date: | 2004-10-29 01:24:54 |
Message-ID: | 1099013094.21161.4.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | Neil Conway <neilc(at)samurai(dot)com> |
Subject: | Re: Suggestion: additional system views |
Date: | 2004-10-29 03:07:43 |
Message-ID: | 200410282007.43934.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2004-10-31 23:49:47 |
Message-ID: | cm3tn7$j9v$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2004-11-01 00:58:15 |
Message-ID: | 20041101005815.GH13884@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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 | Content-Type | Size |
---|---|---|
sqlstate.sql | text/plain | 5.2 KB |
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: | 2004-11-28 03:55:31 |
Message-ID: | 200411280355.iAS3tVV05956@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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(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: | 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 |
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: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-06 21:26:04 |
Message-ID: | 200506061426.04828.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-06 21:35:16 |
Message-ID: | 200506062135.j56LZGk27616@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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(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: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-06 22:36:27 |
Message-ID: | 200506061836.27744.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-06 23:35:58 |
Message-ID: | 200506062335.j56NZwu16110@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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(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: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Suggestion: additional system views |
Date: | 2005-06-07 18:30:50 |
Message-ID: | 200506072030.51008.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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/