psql and ROLES - Mailing list pgsql-hackers

From Stefan Kaltenbrunner
Subject psql and ROLES
Date
Msg-id 42F64B8C.50408@kaltenbrunner.cc
Whole thread Raw
Responses Re: psql and ROLES
List pgsql-hackers
Hi,

I'm currently working on syncing psql's tab-complete code with the docs
especially wrt ROLES. while working on this I noticed the following things:

*) there is no backslash command for getting a list of Roles (like \du &
\dg for Users and Groups) - I'm considering using \dr for that - does
that sound sensible ?

*) the new connectionlimit code allows for negative Limits (beside -1)
like this:

playground=# CREATE ROLE testrole LOGIN CONNECTION LIMIT -999999999;
CREATE ROLE

that doesn't strike me as that useful (and it is not clear what that
should mean anyway because such a user can still login) - so maybe we
should reject that (and create a sensible upper bound for that too)


Stefan


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Cygwin - make check broken
Next
From: Andrew Dunstan
Date:
Subject: Re: Cygwin - make check broken