agora inbox for pgsql-odbc@postgresql.org  

help / color / mirror / Atom feed

From: Färber, Franz-Josef (StMUK) <Franz-Josef.Faerber@stmuk.bayern.de>
To: pgsql-odbc@lists.postgresql.org <pgsql-odbc@lists.postgresql.org>
Subject: Row Versioning with MS Access
Date: Tue, 21 Jul 2026 11:45:01 +0000
Message-ID: <1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de> (raw)

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

Message-ID: <1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de>
Permalink:  ../1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de/
Also on:    postgresql.org/message-id/1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-odbc@postgresql.org
  Cc: Franz-Josef.Faerber@stmuk.bayern.de, pgsql-odbc@lists.postgresql.org
  Subject: Re: Row Versioning with MS Access
  In-Reply-To: <1dfbd19f75cd4301be1e47d64c7cc482@stmuk.bayern.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox