Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-30 Thread Gastón Quiroga
The upgrade works, thank you all ! Gastón Quiroga Allytech S.A. Adrian Klaver wrote: - "Gastón Quiroga" wrote: 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 Allyt

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-29 Thread Adrian Klaver
- "Gastón Quiroga" wrote: > 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?= writes: > > It'

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-29 Thread Alvaro Herrera
Gastón Quiroga wrote: > 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? Use the ctid hidden system field. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Re

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-29 Thread Gastón Quiroga
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?= writes: It's Postgres version 8.0.8 Well, that's pretty a

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-28 Thread Tom Lane
=?ISO-8859-1?Q?Gast=F3n?= 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.

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-28 Thread Gastón
Thanks for your reply Tom, and sorry for the duplicated e-mails. It's Postgres version 8.0.8 Thank you Gastón Quiroga Allytech S.A. Tom Lane wrote: =?ISO-8859-1?Q?Gast=F3n_Quiroga?= writes: I checked the pg_user database and I found this: postgres=# select * from pg_use

Re: [GENERAL] pg_dump ERROR, usename "postgres" duplicated

2009-12-28 Thread Tom Lane
=?ISO-8859-1?Q?Gast=F3n_Quiroga?= writes: > I checked the pg_user database and I found this: > postgres=# select * from pg_user; > usename| usesysid | usecreatedb | usesuper | usecatupd | > passwd | valuntil | useconfig > ---+--+-+--+