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
- "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'
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
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
=?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.
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
=?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
> ---+--+-+--+