Received: from sid.trust.ee (sid.trust.ee [194.204.23.180]) by hub.org (8.8.8/8.7.5) with ESMTP id EAA24912 for ; Wed, 22 Jul 1998 04:51:11 -0400 (EDT) Received: from trust.ee (wink.trust.ee [194.204.23.184]) by sid.trust.ee (8.8.7/8.8.7) with ESMTP id LAA11541; Wed, 22 Jul 1998 11:53:02 +0300 Message-ID: <35B5A8F5.A69D7D22@trust.ee> Date: Wed, 22 Jul 1998 11:55:17 +0300 From: Hannu Krosing X-Mailer: Mozilla 4.05 [en] (Win95; I) MIME-Version: 1.0 To: Michael Yeung CC: "'Interfaces of Postgres'" 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 ! 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