Thread: psql and ROLES

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

Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> *) 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 ?

We could just recycle \du and/or \dg for the purpose.  If those should
still exist as separate commands, what should they do differently from
\dr?  There's no longer any hard-and-fast distinction ...

> *) the new connectionlimit code allows for negative Limits (beside -1)

Right now, any negative value is interpreted as "no limit".  I don't
feel a pressing need to change that.
        regards, tom lane

Tom Lane wrote:
> Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:
> 
>>*) 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 ?
> 
> 
> We could just recycle \du and/or \dg for the purpose.  If those should
> still exist as separate commands, what should they do differently from
> \dr?  There's no longer any hard-and-fast distinction ...

ok - that seems sensible - I will just reuse \du for this

> 
> 
>>*) the new connectionlimit code allows for negative Limits (beside -1)
> 
> 
> Right now, any negative value is interpreted as "no limit".  I don't
> feel a pressing need to change that.

ok - in that case we might consider changing the wording in the docs
from "-1 (the default) means no limit" to something like "any negative
value means no limit"


Stefan