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