Re: problem updating from form

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(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

--

*Karen Springer *

CobhamAvionics, Communications

_karen(dot)springer(at)cobham(dot)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]