Thread: Can't update views with pgsql-odbc
Hello,
I use PostgreSQL 9.2.8 and 9.34 64-bit on Windows or Linux, and psqlodbc v. 09.03.0300 64 bit on Windows 7/ 8.1 Pro.
In my Access 2013 application I can’t delete / insert /modify the views linked on the PostgreSQL server.
These views can be updated by SQL queries in PSQL or pgAdmin III.
So I create à light DB containing only 2 tables and 2 updatable views (one using rules like in PG 8, the other using a trigger) and I try to find a solution …
On a Windows 7 Pro SP1 32-bit box with MS Access 2007 I can modify only if :
- Using a System Data Source (located in registry HKLM\Software\ODBC) with :
o The postgres user
o Connecting to a PostgreSQL 9.2.8 on CentOS 6.5 64-bits
o Using the defauts values
- The view based on rules works, not the other using trigger (new in PG 9.1)
On the 64-bit boxes, Windows 7 Pro SP1 and Windows 8.1 Update 1, no result.
Is the PG ODBC driver permitting to update a view or not ?
I can send you my test database (8 KB) for your tests …
Thanks for any solution.
Luc ROLLAND
luc@rolland-fr.com