Обсуждение: xmin field in a newly created table.

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

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

- Jose' -

"No other success in life can compensate for failure in the home" (David O.
McKay)

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