Re: problem updating from form

Karen Springer <karen(dot)springer(at)cobham(dot)com> writes:
> I have a problem that has me stumped. We have a table that is the main
> table in a production Microsoft Access application. Our users are
> complaining that sometimes they enter data in the form, move off of the
> record & then upon returning to the record the data reverts back to what
> existed in the field prior to the entry.

FWIW, that sounds like it's entirely a client-side issue. So you might
have better luck asking about it in pgsql-odbc.

> We are using PostgreSQL 8.1.4 on Red Hat, Microsoft Access 2002 &
> psqlodbc_09_00_0200.

As noted elsewhere, 8.1.4 is really old (more than 4 years old in fact).
It's likely not helping any that you're using a fresh-off-the-boat
psqlodbc version with it --- I don't know that anyone would have done
any significant testing of 09_00_0200 against an 8.1.x server.

Red Hat is currently shipping Postgres 8.4.x for RHEL-5 (see the
"postgresql84" package set). It'd be a good thing to consider updating
to 8.4.x sometime soon. I doubt it'll fix this immediate problem, but
it will likely save your data from getting eaten sometime in the future.

regards, tom lane