Hiroshi, thank you for all the good work you do on the postgres odbc drivers, they make my life easier.
>When refreshing linked tables, is Row Versioning still checked?
Row versioning is selected in the File DSN (data source name) of the Windows ODBC Data Source Administrator, so using the Access Linked Table Manager has no effect on that.
>What connection strings do you see using linked table manager?
Here is one from a table that 'loses' xmin after linked table manager refreshes the link:
ODBC;DRIVER={PostgreSQL Unicode};DATABASE=planning_services;SERVER=198.31.87.25;PORT=5432;CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;CX=1bd01bb;A1=7.4-1;TABLE=public.policies
I just noticed that xmin is not lost after a refresh when the driver is PostgreSQL ANSI.
Hope this helps!
Fred
> Hi Fred,
On 2016/10/18 23:40, Fred Parkinson wrote:
When you first link to a PostgreSQL table in MS Access (File>Get External Data>Link tables...) with Row Versioning on, then observe the table structure, xmin shows up as the last field, type long integer.
Then when you refresh the link using the Access Linked Table Manager and again observe the table structure, xmin no longer appears to be present.
Thanks for the info.
May I ask some questions?
When refreshing linked tables, is Row Versioning still checked?
What connection strings do you see using linked table manager?
regards,
Hiroshi Inoue