Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate user in pg_shadow - Mailing list pgsql-performance

From Tom Lane
Subject Re: Duplicate user in pg_shadow
Date
Msg-id 25474.1067487966@sss.pgh.pa.us
Whole thread Raw
In response to Duplicate user in pg_shadow  (CHEWTC@ap.nec.com.sg)
List pgsql-performance
Tree view 
CHEWTC@ap.nec.com.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

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
Next
From: CHEWTC@ap.nec.com.sg
Date:
Subject: Re: Duplicate user in pg_shadow