Postgres Pro
Downloads
Home   >   mailing lists

Thread: xmin when linked tables are updated?

xmin when linked tables are updated?

From
James Bellinger
Date:
Hello,

I am finding that with Row Versioning enabled, MS Access 2003 picks up
xmin when I initially link the table, but when I refresh the table, it
disappears. Is this version of Access incompatible with psqlODBC's Row
Versioning, is there some other setting I need, or...? I'd like to give
it a try.

Thanks!

James

Re: xmin when linked tables are updated?

From
"Inoue, Hiroshi"
Date:
Hi James.

On 2016/10/14 21:27, James Bellinger wrote:
> Hello,
>
> I am finding that with Row Versioning enabled, MS Access 2003 picks up
> xmin when I initially link the table, but when I refresh the table, it
> disappears.

Could you tell me what *disappears* means more concretely? Unfortunately
I can't touch MS Access.

regards,
Hiroshi Inoue

Re: xmin when linked tables are updated?

From
"Fred Parkinson"
Date:
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.

My question is: so what? Does this have an effect on your application James? I have used odbc to link Access to postgres for almost 20 years and have had very few issues, but I have to admit I have never used the Linked Table Manager. When I make a structure change to a postgres table I just use File>Get External Data... again.

Does the apparent disappearance of xmin have an effect on your application?
>>> "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp> 10/16/2016 3:12 PM >>>
Hi James.

On 2016/10/14 21:27, James Bellinger wrote:
> Hello,
>
> I am finding that with Row Versioning enabled, MS Access 2003 picks up
> xmin when I initially link the table, but when I refresh the table, it
> disappears.

Could you tell me what *disappears* means more concretely? Unfortunately
I can't touch MS Access.

regards,
Hiroshi Inoue


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: xmin when linked tables are updated?

From
"Inoue, Hiroshi"
Date:
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

Re: xmin when linked tables are updated?

From
"Fred Parkinson"
Date:
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
>>> "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp> 10/19/2016 8:58 PM >>>
> 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

Re: xmin when linked tables are updated?

From
"Inoue, Hiroshi"
Date:
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

Re: xmin when linked tables are updated?

From
"Fred Parkinson"
Date:
Hiroshi

>Does the connection string change after a refresh?
I can verify from my table that 'lost' xmin, that the connection string as exposed by Access has not changed.

But what's worse, this morning I tried to reproduce the problem, about 8 times, but refreshing with the linked table manager no longer disappears the xmin column!
I tried this on 3 different linked tables, and in spite of all I could do with the linked table manager I could not make xmin disappear again!

Sometimes I think I don't understand computers.

Fred
>>> "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp> 10/21/2016 6:48 AM >>>
> 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