From: | brendanl(at)iname(dot)com (Brendan LeFebvre) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Stubborn lock(?) with psqlODBC+MSAccess |
Date: | 2002-07-17 21:52:51 |
Message-ID: | cf7bc53b.0207171352.5b95eca4@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm running PG7.2.1 on RedHat 7.2 with the latest psqlODBC as my
database backend, with a Win98SE box running Access97 as the front
end.
I UPDATEd a record from the linux box in psql.
Now, when I attempt to UPDATE that same record from MSAccess, I get a
"Write lock" notice with no choice but to "Copy Changes to Clipboard"
or "Drop Changes." (the "save changes" button is grayed out.)
I have tried multiple stops/restarts of postmaster, a VACUUM, and a
review of /tmp for stray lockfiles (there were none) and still this
behavior in Access, for this one particular record, persists.
However, I can UPDATE this record as much as I like from psql and in
pgAdmin.
----
Possibly related bad behavior:
Within access, if I try to edit the same record multiple times in the
same connect session, the first keystroke of the second and subsequent
edits yields the dialog:
"The data has changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the
record."
After which I can make my edit without incident.
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2002-07-17 22:06:41 | pg_restore: archiver error |
Previous Message | Rosario Peluso | 2002-07-17 20:39:45 | Command execution goes stuck... |