\c connects as another user instead I want in psql

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: \c connects as another user instead I want in psql
Date: 2001-05-02 16:40:30
Message-ID: Pine.LNX.4.21.0105021834010.24311-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-05-02 17:35:37 New Linux xfs/reiser file systems
Previous Message Jeff Vainio 2001-05-02 15:30:51 help!