Re: [HACKERS] todo: comment field for pg users and groups

2004-09-22 Thread Rod Taylor
> There have been noises of adding a new catalog for keeping comments for > shared objects (which would itself be shared, of course). I'm not sure > what the rationale is for not putting them in the pg_shadow catalog. Does TOAST work on shared objects? ---(end of broadca

Re: [HACKERS] todo: comment field for pg users and groups

2004-09-22 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > There have been noises of adding a new catalog for keeping comments for > shared objects (which would itself be shared, of course). I'm not sure > what the rationale is for not putting them in the pg_shadow catalog. The fact that it wouldn't scale conv

Re: [HACKERS] todo: comment field for pg users and groups

2004-09-22 Thread Fabien COELHO
Dear Alvaro, Thus I would suggest to add one new text field in pg_group and pg_shadow for this purpose, that could be initialized with something like: CREATE USER calvin COMMENT 'Calvin <[EMAIL PROTECTED]>'; Alternatively, it could be managed with "COMMENT ON ..."? Well, users or groups are

Re: [HACKERS] todo: comment field for pg users and groups

2004-09-22 Thread Alvaro Herrera
On Wed, Sep 22, 2004 at 01:15:42PM +0200, Fabien COELHO wrote: > As I'm managing accounts for students... I noticed that there does not > seem to be a proper way to keep a comment about a postgresql user account, > such as the full name of the student or its email, that I could see with > \du o