Create role with login

testdb=> create role role_test with LOGIN;
CREATE ROLE
testdb=> select rolcanlogin from pg_roles where rolname = ‘role_test’;
rolcanlogin

f
(1 row)

$ psql -h 192.168.26.157 -p 26257 testdb -U role_test
psql (10.6 (Ubuntu 10.6-0ubuntu0.18.04.1), server 9.5.0)
Type “help” for help.

testdb=>

so looks like the “with login” is honored but pg_roles doesn’t reflect it

Hi there,

I submitted this GitHub issue to track this.

This likely a pg_catalog bug.