This may be a reported bug. 7.1beta4.
I use user names mostly as numbers. E.g. 1050, 1060, 1092.
Sometimes I got strange result when I try to reconnect:
tir=> \c - 1022
You are now connected as new user 1022.
tir=> select user;
current_user
--------------
1022
(1 row)
(It's OK.)
tir=> \c - 1060
You are now connected as new user 1060.
tir=> select user;
current_user
--------------
1092
(1 row)
This is the problematic point. Is this a solved bug?
TIA, Zoltan
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster