Your patch has been added to the PostgreSQL unapplied patches list at:

        http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Brendan Jurd wrote:
> I've done up a patch per Tom's idea of combining the binary role
> attributes into a single column.
> 
> Each attribute which differs from the default is listed on a separate
> line, like so:
> 
>                   List of roles
>   Role name  |   Attributes   |     Member of
> -------------+----------------+-------------------
>  bob         |                | {readers,writers}
>  brendanjurd | Superuser      | {}
>              : Create role
>              : Create DB
>  harry       | No inherit     | {}
>  jim         | 10 connections | {readers}
>  readers     | No login       | {}
>  writers     | No login       | {}
> (6 rows)
> 
> Notes:
> 
>  * The patch relies on array_to_string's current treatment of NULL
> values in the array; they are ignored.  If that behaviour changes in
> the future, the \du output will become very ugly indeed.
>  * I'm not sure whether "No login" and "No inherit" are the best
> phrases to use.  I took my cue from the SQL setting names NOLOGIN and
> NOINHERIT, but maybe something more grammatically sensible with
> "Cannot login" and "No inheritance" would be preferable.
>  * If accepted, this patch would supercede the earlier patch mentioned
> by Bernd Helmle upthread, which adds LOGIN to the output as a new
> column: http://archives.postgresql.org/pgsql-patches/2007-11/msg00014.php
> 
> Cheers,
> BJ

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers

Reply via email to