Postgres Pro
Downloads
Home   >   mailing lists

Thread: 'xmin' column in the Access 97

'xmin' column in the Access 97

From
Michael Yeung
Date:
Dear all,

I am using the latest ODBC Driver to connect to the Postgres DataBase ! Then I use Access 97 to link the table in the
postgresdatabase with this latest ODBC Driver behind a firewall.  

However, an additional column called 'xmin' appears for which contains a six digit number. This 'xmin' column IS NOT
CREATEDin the Postgres Database ! 

Have anyone of you experienced the similar problem ? Any suggestions and solutions will be highly appreciated.

Thank you for your attention !

Cheers,
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
| Michael Yeung                 |
| Alpha Network Shop            |
| Tel:(02)9413-3886        Fax:(02)9413-3617    |
| Mobile:0411-233-597            |
| mailto:michaely@alphanet.net.au        |
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/

Re: [INTERFACES] 'xmin' column in the Access 97

From
Hannu Krosing
Date:
Michael Yeung wrote:
>
> Dear all,
>
> I am using the latest ODBC Driver to connect to the Postgres DataBase !
> Then I use Access 97 to link the table in the postgres database with
> this latest ODBC Driver behind a firewall.
>
> However, an additional column called 'xmin' appears for which
> contains a six digit number. This 'xmin' column IS NOT CREATED
> in the Postgres Database !

This is one of the "system" columns in PostgreSQL (minimum transaction,
i think), there ar also others - oid, xmax, cmin, tmax,ctid.

Have you checked system tables or system columns anywhere in the driver
setup ?

Do you also see any other system columns ?

Hannu

Re: [INTERFACES] 'xmin' column in the Access 97

From
David Hartwig
Date:

Michael Yeung wrote:

> Dear all,
>
> I am using the latest ODBC Driver to connect to the Postgres DataBase ! Then I use Access 97 to link the table in the
postgresdatabase with this latest ODBC Driver behind a firewall. 
>
> However, an additional column called 'xmin' appears for which contains a six digit number. This 'xmin' column IS NOT
CREATEDin the Postgres Database ! 
>
> Have anyone of you experienced the similar problem ? Any suggestions and solutions will be highly appreciated.
>

You have Row Versioning turned on in the driver.   You can either manually hide the field via Access properties, or
turnit off  the feature in the driver.   Check Advanced Options - 
DataSource.   Before you do so, you may want to refer to  http://www.insightdist.com/psqlodbc/psqlodbc_confighelp.html
formore details.  Look for Advanced Options - Row Versioning and 
be sure to check out the faq (http://www.insightdist.com/psqlodbc/psqlodbc_faq.html) on this issue.