Re: [INTERFACES] xmin field in a newly created table. - Mailing list pgsql-interfaces

From Valerio Santinelli
Subject Re: [INTERFACES] xmin field in a newly created table.
Date
Msg-id 36D4288B.EFBC1570@mediacom.it
Whole thread Raw
In response to xmin field in a newly created table.  (Valerio Santinelli <tanis@mediacom.it>)
List 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



pgsql-interfaces by date:

Previous
From: Valerio Santinelli
Date:
Subject: Error with MSAccess97 subforms and PostODBC
Next
From: "Tobias Eriksson"
Date:
Subject: SV: SV: [INTERFACES] couldn't start postmaster - couldn't allocate sharedmemory