Tom Lane <[EMAIL PROTECTED]> writes:
> No. I'm not sure whether or not I believe the comment about Unix
> accounts; Postgres does not care about Unix accounts, and never has
> to my knowledge. But it has always used the usesysid as owner
> identification for database objects (tables etc). If t
Zeugswetter Andreas SB <[EMAIL PROTECTED]> writes:
> 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
> >> 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
