Re: pg_dump ERROR, usename "postgres" duplicated

Поиск
Список
Период
Сортировка
От Gastón Quiroga
Тема Re: pg_dump ERROR, usename "postgres" duplicated
Дата
Msg-id 4B3A24CA.6030309@allytech.com
обсуждение исходный текст
Ответ на Re: pg_dump ERROR, usename "postgres" duplicated  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pg_dump ERROR, usename "postgres" duplicated  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: pg_dump ERROR, usename "postgres" duplicated  (Adrian Klaver <aklaver@comcast.net>)
Список pgsql-general
Thank You Tom:
    I'll Try to make an update, but the 2 fields are equals row by row, how could I make a difference in the "WHERE" statement?

Regards

Gastón Quiroga
Allytech S.A.


Tom Lane wrote:
Gastón <tango@allytech.com> writes: 
It's Postgres version 8.0.8   
Well, that's pretty ancient, and I see at least one bug in the release
history that could result in duplicated rows.  I'd counsel an update to
8.0.something-recent.  You can probably delete the extra row using
a WHERE on ctid.
		regards, tom lane 

В списке pgsql-general по дате отправления:

Предыдущее
От: svcntk
Дата:
Сообщение: esql vs libpq
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pg_dump ERROR, usename "postgres" duplicated