Re: BUG #1161: User permissions are kept, even if user is

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