| From: | Färber, Franz-Josef (StMUK) <Franz-Josef(dot)Faerber(at)stmuk(dot)bayern(dot)de> |
|---|---|
| To: | "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
| Subject: | Row Versioning with MS Access |
| Date: | 2026-07-21 11:45:01 |
| Message-ID: | 1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Dear Mailing List,
I'm trying to get Row Versioning to work with MS Access; but I am unfortunate so far.
Program Versions:
* MS Access 365
* PsqlODBC 17.00.00.06
* Postgres 18.4
What I tried:
* add either RowVersioning=1 or A4=1 into the connection string
* create a linked table with this connection string in MS Access
* edit some row of this table in MS Access
* In Postgres, having ALTER SYSTEM SET log_statement TO 'all', looking if the corresponding UPDATE statement still has a WHERE clause citing ALL columns, or by now would use the XMIN column.
My reference was:
* https://odbc.postgresql.org/docs/config.html
* https://odbc.postgresql.org/docs/config-opt.html
* https://odbc.postgresql.org/faq.html#4.3
Additional notes:
* I suppose the FAQ 4.3 Item about a missing operator=(xid, int4) is just for veeery old Postgres versions? I tested SELECT '12'::xid = 12::int4 and it worked with my Postgres 18.4 .
Do my proceedings make sense?
* How can I detect psqlODBC Row Versioning working? By moticing an additional column XMIN in the MS Access linked table? Well, this is not the case.
* Does MS Access pick up this feature at all?
Thank You.
Regards,
Franz-Josef Färber
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 2026-07-22 05:26:26 | AW: Row Versioning with MS Access | |
| Previous Message | Arthur Bazin | 2026-07-07 19:45:44 | Using pgpass and pg_config files with psqlODBC |