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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED]) -- 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
