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

[Tom Lane]

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

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