Stubborn lock(?) with psqlODBC+MSAccess
От | brendanl@iname.com (Brendan LeFebvre) |
---|---|
Тема | Stubborn lock(?) with psqlODBC+MSAccess |
Дата | |
Msg-id | cf7bc53b.0207171352.5b95eca4@posting.google.com обсуждение исходный текст |
Список | 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.
В списке pgsql-general по дате отправления: