pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feed'xmin' column in the Access 97
3+ messages / 3 participants
[nested] [flat]
* 'xmin' column in the Access 97
@ 1998-07-22 01:36 Michael Yeung <michaely@alphanet.net.au>
0 siblings, 2 replies; 3+ messages in thread
From: Michael Yeung @ 1998-07-22 01:36 UTC (permalink / raw)
To: pgsql-interfaces
Dear all,
I am using the latest ODBC Driver to connect to the Postgres DataBase ! Then I use Access 97 to link the table in the postgres database with this latest ODBC Driver behind a firewall.
However, an additional column called 'xmin' appears for which contains a six digit number. This 'xmin' column IS NOT CREATED in the Postgres Database !
Have anyone of you experienced the similar problem ? Any suggestions and solutions will be highly appreciated.
Thank you for your attention !
Cheers,
/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\
| Michael Yeung |
| Alpha Network Shop |
| Tel:(02)9413-3886 Fax:(02)9413-3617 |
| Mobile:0411-233-597 |
| mailto:michaely@alphanet.net.au |
\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] 'xmin' column in the Access 97
@ 1998-07-22 08:55 Hannu Krosing <hannu@trust.ee>
parent: Michael Yeung <michaely@alphanet.net.au>
1 sibling, 0 replies; 3+ messages in thread
From: Hannu Krosing @ 1998-07-22 08:55 UTC (permalink / raw)
To: Michael Yeung <michaely@alphanet.net.au>; +Cc: pgsql-interfaces
Michael Yeung wrote:
>
> Dear all,
>
> I am using the latest ODBC Driver to connect to the Postgres DataBase !
> Then I use Access 97 to link the table in the postgres database with
> this latest ODBC Driver behind a firewall.
>
> However, an additional column called 'xmin' appears for which
> contains a six digit number. This 'xmin' column IS NOT CREATED
> in the Postgres Database !
This is one of the "system" columns in PostgreSQL (minimum transaction,
i think), there ar also others - oid, xmax, cmin, tmax,ctid.
Have you checked system tables or system columns anywhere in the driver
setup ?
Do you also see any other system columns ?
Hannu
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] 'xmin' column in the Access 97
@ 1998-07-22 12:59 David Hartwig <daveh@insightdist.com>
parent: Michael Yeung <michaely@alphanet.net.au>
1 sibling, 0 replies; 3+ messages in thread
From: David Hartwig @ 1998-07-22 12:59 UTC (permalink / raw)
To: Michael Yeung <michaely@alphanet.net.au>; +Cc: pgsql-interfaces
Michael Yeung wrote:
> Dear all,
>
> I am using the latest ODBC Driver to connect to the Postgres DataBase ! Then I use Access 97 to link the table in the postgres database with this latest ODBC Driver behind a firewall.
>
> However, an additional column called 'xmin' appears for which contains a six digit number. This 'xmin' column IS NOT CREATED in the Postgres Database !
>
> Have anyone of you experienced the similar problem ? Any suggestions and solutions will be highly appreciated.
>
You have Row Versioning turned on in the driver. You can either manually hide the field via Access properties, or turn it off the feature in the driver. Check Advanced Options -
DataSource. Before you do so, you may want to refer to http://www.insightdist.com/psqlodbc/psqlodbc_confighelp.html for more details. Look for Advanced Options - Row Versioning and
be sure to check out the faq (http://www.insightdist.com/psqlodbc/psqlodbc_faq.html) on this issue.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-07-22 12:59 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-22 01:36 'xmin' column in the Access 97 Michael Yeung <michaely@alphanet.net.au>
1998-07-22 08:55 ` Hannu Krosing <hannu@trust.ee>
1998-07-22 12:59 ` David Hartwig <daveh@insightdist.com>
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