Re: xmin when linked tables are updated?

Hi Fred,

On 2016/10/21 0:43, Fred Parkinson wrote:
> 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

Thanks.
Though I'm testing refreshLink using DAO, I can't reproduce the behavior.
Does the connection string change after a refresh?

>
> I just noticed that xmin is not lost after a refresh when the driver
> is PostgreSQL ANSI.

Hmm strange, I can't think of suspicious points immediately.

regards,
Hiroshi Inoue