Received: from geode.mediacom.it (geode.mediacom.it [194.184.0.2]) by hub.org (8.9.2/8.9.1) with ESMTP id LAA58421 for ; Wed, 24 Feb 1999 11:31:07 -0500 (EST) (envelope-from tanis@mediacom.it) Received: from mediacom.it (root@lotus.mediacom.it [194.184.0.11]) by geode.mediacom.it (8.9.1/8.9.1) with ESMTP id RAA00539; Wed, 24 Feb 1999 17:26:35 +0100 Sender: root@geode.mediacom.it Message-ID: <36D4288B.EFBC1570@mediacom.it> Date: Wed, 24 Feb 1999 17:27:55 +0100 From: Valerio Santinelli Organization: Mediacom X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.35 i686) MIME-Version: 1.0 To: "jose' soares" CC: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] xmin field in a newly created table. References: <36D3D839.7CE659E3@mediacom.it> <36D4078F.C54310BD@bo.nettuno.it> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit jose' soares wrote: > Valerio Santinelli ha scritto: > > > I created a new table named "test" and with something like a dozen > > fields of different kind. > > When viewed through psql everything looks fine. If I link the table into > > MSAccess97 I get a new field called "xmin" that I don't know where it > > came from ? Any idea ?? > > > > Valerio Santinelli > > xmin is the row versioning that Msaccess uses for speedy concurrent access > to database, if you don't want to use this > Msaccess feature you have to uncheck "row Versioning" field on PostgreSQL > driver setup (advanced) in > ODBC data source administrator Yeah. I did it and now it works fine. I've also got to make all my boolean fields into int2 otherwise MSAccess won't let me update any record. Valerio Santinelli