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.
In response to
pgsql-interfaces by date
|Next:||From: Bruce Momjian||Date: 1998-07-22 13:58:19|
|Subject: Re: [HACKERS] atttypmod now 32 bits, interface change|
|Previous:||From: Hannu Krosing||Date: 1998-07-22 08:55:17|
|Subject: Re: [INTERFACES] 'xmin' column in the Access 97|