Re: problem updating from form - Mailing list pgsql-general
| From | Karen Springer |
|---|---|
| Subject | Re: problem updating from form |
| Date | |
| Msg-id | 4D216CDD.2070803@cobham.com Whole thread Raw |
| In response to | Re: problem updating from form (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: problem updating from form
|
| List | pgsql-general |
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@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
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.; Prescott, Arizona USA]
pgsql-general by date: