Re: [HACKERS] \c connects as another user instead I want in psql

[Kovacs Zoltan]

On Wed, 2 May 2001, Tom Lane wrote:

> Kovacs Zoltan <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster