Row Versioning with MS Access

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

Responses

Browse pgsql-odbc by date

  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