pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedxmin field in a newly created table.
3+ messages / 2 participants
[nested] [flat]
* xmin field in a newly created table.
@ 1999-02-24 10:45 Valerio Santinelli <tanis@mediacom.it>
1999-02-24 14:07 ` Re: [INTERFACES] xmin field in a newly created table. jose' soares <sferac@bo.nettuno.it>
0 siblings, 1 reply; 3+ messages in thread
From: Valerio Santinelli @ 1999-02-24 10:45 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] xmin field in a newly created table.
1999-02-24 10:45 xmin field in a newly created table. Valerio Santinelli <tanis@mediacom.it>
@ 1999-02-24 14:07 ` jose' soares <sferac@bo.nettuno.it>
1999-02-24 16:27 ` Re: [INTERFACES] xmin field in a newly created table. Valerio Santinelli <tanis@mediacom.it>
0 siblings, 1 reply; 3+ messages in thread
From: jose' soares @ 1999-02-24 14:07 UTC (permalink / raw)
To: Valerio Santinelli <tanis@mediacom.it>; +Cc: pgsql-interfaces
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] xmin field in a newly created table.
1999-02-24 10:45 xmin field in a newly created table. Valerio Santinelli <tanis@mediacom.it>
1999-02-24 14:07 ` Re: [INTERFACES] xmin field in a newly created table. jose' soares <sferac@bo.nettuno.it>
@ 1999-02-24 16:27 ` Valerio Santinelli <tanis@mediacom.it>
0 siblings, 0 replies; 3+ messages in thread
From: Valerio Santinelli @ 1999-02-24 16:27 UTC (permalink / raw)
To: jose' soares <sferac@bo.nettuno.it>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1999-02-24 16:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-24 10:45 xmin field in a newly created table. Valerio Santinelli <tanis@mediacom.it>
1999-02-24 14:07 ` jose' soares <sferac@bo.nettuno.it>
1999-02-24 16:27 ` Valerio Santinelli <tanis@mediacom.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox