Re: [INTERFACES] xmin field in a newly created table.

From: Valerio Santinelli <tanis(at)mediacom(dot)it>
To: "jose' soares" <sferac(at)bo(dot)nettuno(dot)it>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] xmin field in a newly created table.
Date: 1999-02-24 16:27:55
Message-ID: 36D4288B.EFBC1570@mediacom.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Meskes 1999-02-24 20:36:40 Re: [INTERFACES] Newbie Q: How to deal with date/time with libpq or ecpg?
Previous Message Valerio Santinelli 1999-02-24 16:11:15 Error with MSAccess97 subforms and PostODBC