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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
