Re: BUG #1161: User permissions are kept, even if user is - Mailing list pgsql-bugs

little example of generating usesysid

    create user test sysid 2147483647;
CREATE USER
    create user test1;
CREATE USER
    select * from pg_shadow;
 usename  |  usesysid   | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+-------------+-------------+----------+-----------+--------+----------+-----------
 postgres |           1 | t           | t        | t         |
|          |
 test     |  2147483647 | f           | f        | f         |
|          |
 test1    | -2147483648 | f           | f        | f         |
|          |
(3 rows)

    create user test2;
psql:./tt:5: ERROR:  duplicate key violates unique constraint
"pg_shadow_usesysid_index"

And I have still a question:
How to remove privileges of the nonexistent (removed) user?
And the offer:
Can realize removal of privileges of nonexistent users during time vacuum?

PS: Sorry for my ugly english