Karen Springer <karen.springer@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
