| From: | "Agnelo Roneberg" <aroneberg(at)bergfone(dot)com> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Access ODBC View update problem (#deleted) |
| Date: | 2006-08-24 20:56:10 |
| Message-ID: | 8202DB88944E224B9F64DC2120DBD31E2539B5@servidor-rede.rede.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi,
sw versions :
-PG 8.1.4
-windows 2000 server (fully patched)
-odbc ANSI 8.01.02
-Access 2003 (fully patched)
A Postgres view (linked as table) is been used as a Access form record
source. The view has Update rules and runs ok from pgAdmin for instance.
Sometimes when the user updates some data on the form he gets the
#deleted on all fields (I'm not able to reproduce it).
Primary key is defined when linking the view as table. Row source
versioning is defined in the odbc driver (and it solved the same problem
with tables).
I'm able to see xmin field in the linked tables but not in the linked
views, therefore the problem with the update AFAIK.
What should I do to correct this #deleted behaviour ? Is there a way to
include xmin in the linked views ?
best regards,
Roneberg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Bense | 2006-08-24 23:00:35 | Re: Access ODBC View update problem (#deleted) |
| Previous Message | noreply | 2006-08-24 19:40:23 | [ psqlodbc-Bugs-1000714 ] Driver gets progressively slower Multi-threading retrieval |