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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: \c connects as another user instead I want in psql
Date: 2001-05-03 13:07:30
Message-ID: 23617.988895250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mauricio Breternitz 2001-05-03 13:20:05 Re: PostgreSQL replication
Previous Message Matthew Kirkwood 2001-05-03 12:23:02 Re: Re: New Linux xfs/reiser file systems