Message-Id: <35B5E218.65B8E874@insightdist.com>
Date: Wed, 22 Jul 1998 08:59:04 -0400
From: David Hartwig <daveh@insightdist.com>
Organization: Insight Distribution Systems
Mime-Version: 1.0
To: Michael Yeung <michaely@alphanet.net.au>
Cc: "'Interfaces of Postgres'" <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] 'xmin' column in the Access 97
References: <01BDB564.EFA72E70@wynyard.alphanet.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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 !
>
> 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 turn it 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  for more 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.