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.sprin...@cobham.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
--
*Karen Springer *
CobhamAvionics, Communications
_karen.sprin...@cobham.com_
CheltonAvionics dba Wulfsberg has begun its transition to Cobham Avionics
however, at this time, all business transactions continue to remain with
Wulfsberg Electronics.
CheltonAvionics 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,
pleasedelete 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
companyor any subsidiary or affiliate or associated company into a
contract or to
createany legally binding obligations unless expressly agreed to in
writing under
separatecover 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.; Prescott, ArizonaUSA]
