Re: Values not being updated.

[Dave Page <dpage(at)postgresql(dot)org>]

Maximiliano Pin wrote:
> We found this bug: after some weeks using a database, updates to some
> table values from pgadmin are always ignored. They're aparently updated
> without error, but closing the window and opening the table again shows
> the value has not been changed. Adding OIDs to that table, sometimes
> fixes the problem, sometimes not. Then, we must use command line psql to
> update values.
> 
> Using pgadmin III 1.6.2 (Windows 2000) with postgres 8.1.2 (HP-UX).

Does it happen with 1.6.3? If so, can you please turn the log level up
to include SQL (under File->Options->Logging), recreate the problem and
check the log to see what's wring with the query?

There was a bug fixed the other day (but not in time for 1.6.3) which
would cause the key to be incorrectly generated if any of the columns in
the primary key were empty strings. It's possible this is the cause.

Regards, Dave