Search Postgresql Archives

Re: pg_dump ERROR, usename "postgres" duplicated

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:
=?ISO-8859-1?Q?Gast=F3n?= <tango@xxxxxxxxxxxx> 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
  

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux