\c connects as another user instead I want in psql - Mailing list pgsql-hackers

From Kovacs Zoltan
Subject \c connects as another user instead I want in psql
Date
Msg-id Pine.LNX.4.21.0105021834010.24311-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
Responses Re: \c connects as another user instead I want in psql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Olivier PRENANT
Date:
Subject: change database owner
Next
From: Michael Samuel
Date:
Subject: Re: Thanks, naming conventions, and count()