|
Hi Tom, Due to the responses I received, I am now thoroughly convinced of the need to upgrade & have passed this information on. We are running RHEL 4.1 which is why the newer version did not install with RHEL. I initially was using an older version of psqlodbc, but decided to upgrade to the latest on my test machine hoping it would help. The users have the older psqlodbc. I will ask the pgsql-odbc group next. Thank you for your suggestions! Best regards, Karen On 01/02/2011 9:41 AM, Tom Lane wrote: 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 --
Karen Springer Cobham
Avionics, Communications Chelton
Avionics dba Wulfsberg
has begun its transition to Cobham
Avionics however,
at this time, all business transactions continue to
remain with Wulfsberg
Electronics. Chelton
Avionics dba Wulfsberg
Electronics doing business as Cobham
Avionics Registered
office: 6400 Wilkinson Drive, Prescott, AZ 86301 USA
Please
consider the environment
before printing this email. THIS EMAIL
AND ANY ATTACHED FILES ARE CONFIDENTIAL AND MAY BE LEGALLY
PRIVILEGED. This e-mail and any files
transmitted with it ("E-mail") is intended solely
for the addressee(s) and may
contain confidential and/or legally privileged
information. If you are not the
addressee(s), any
disclosure, reproduction, copying, distribution Or other use of the
E-mail is
prohibited. If you have received this E-mail in
error, please delete
it and notify the sender
immediately via our switchboard or return e-mail. Neither the company nor
any
subsidiary or affiliate or associated company nor
any individual sending
this E-mail accepts any liability in respect of the
content (including
errors and omissions) nor shall this e-mail be
deemed to enter the company or any
subsidiary or affiliate or
associated company into a contract or to create any
legally binding obligations
unless expressly agreed to in writing under separate cover
and timeliness of the E-mail which
arise as a result of transmission. If verification is
required, please
request a hard copy version from the sender. [Cobham
Avionics, Inc.; |
