Access ODBC View update problem (#deleted) - Mailing list pgsql-odbc

From Agnelo Roneberg
Subject Access ODBC View update problem (#deleted)
Date
Msg-id 8202DB88944E224B9F64DC2120DBD31E2539B5@servidor-rede.rede.local
Whole thread Raw
List 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



pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000714 ] Driver gets progressively slower Multi-threading retrieval
Next
From: "Peter Bense"
Date:
Subject: Re: Access ODBC View update problem (#deleted)