Re: Duplicate user in pg_shadow

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Duplicate user in pg_shadow
Дата
Msg-id 25474.1067487966@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Duplicate user in pg_shadow  (CHEWTC@ap.nec.com.sg)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: PostgreSQL 7.4beta5 vs MySQL 4.0.16 with RT(DBIx::SearchBuilder)
Следующее
От: CHEWTC@ap.nec.com.sg
Дата:
Сообщение: Re: Duplicate user in pg_shadow