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

Kovacs Zoltan <kovacsz@pc10.radnoti-szeged.sulinet.hu> writes:
>> 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?

Yup, there should be one (and one on usename, too).  Not sure why it's
been overlooked so far.
        regards, tom lane