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