| From: | "Fred Parkinson" <FredP(at)abag(dot)ca(dot)gov> |
|---|---|
| To: | <h-inoue(at)dream(dot)email(dot)ne(dot)jp>, <james(at)illusorystudios(dot)com> |
| Cc: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Re: xmin when linked tables are updated? |
| Date: | 2016-10-18 14:40:00 |
| Message-ID: | 5805D1D0020000A7000369CF@gwia1.abag.ca.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
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(at)dream(dot)email(dot)ne(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jon Raiford | 2016-10-18 19:59:47 | DIAG [HY000] server closed the connection unexpectedly |
| Previous Message | Inoue, Hiroshi | 2016-10-16 22:12:54 | Re: xmin when linked tables are updated? |