Обсуждение: 'xmin' column in the Access 97
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 | \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
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
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.