| From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
|---|---|
| To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | AW: \c connects as another user instead I want in psql |
| Date: | 2001-05-03 13:38:57 |
| Message-ID: | 11C1E6749A55D411A9670001FA6879633682AD@sdexcsrv1.f000.d0188.sd.spardat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> >> 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.
The usesysid was originally intended to map pg users to unix accounts.
I do not see why it should not be possible to map different pg users
to a single unix account. The above imho stems from an improper use of this
column which needs to be fixed, not the column made unique.
Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-05-03 13:51:16 | Re: AW: \c connects as another user instead I want in psql |
| Previous Message | Tom Lane | 2001-05-03 13:33:11 | Re: Re: New Linux xfs/reiser file systems |