Re: Duplicate user in pg_shadow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: CHEWTC(at)ap(dot)nec(dot)com(dot)sg
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Duplicate user in pg_shadow
Date: 2003-10-30 04:26:06
Message-ID: 25474.1067487966@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

CHEWTC(at)ap(dot)nec(dot)com(dot)sg writes:
> When I do a SELECT * FROM pg_shadow, I can have more than one user
> with the same id. This caused the pg_dump to fail.
> I read that it happened in v7.1.2 and I am currently using v7.3.2

This is *real* hard to believe. Versions 7.2 and later have a unique
index on pg_shadow.usesysid. Are you certain the server isn't 7.1 or
older?

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message CHEWTC 2003-10-30 04:26:43 Re: Duplicate user in pg_shadow
Previous Message Christopher Kings-Lynne 2003-10-30 04:24:50 Re: Duplicate user in pg_shadow