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

On Wed, 2 May 2001, Tom Lane wrote:

> Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
> > tir=> \c - 1060
> > You are now connected as new user 1060.
> > tir=> select user;
> >  current_user
> > --------------
> >  1092
> > (1 row)
> 
> Is it possible that 1060 and 1092 have the same usesysid in pg_shadow?
Hmmm. That was the problem. Thanks! By the way, could you please define a
unique constraint on column 'usesysid' in future in PostgreSQL?

Zoltan