From: Byron Nikolaidis <byronn@insightdist.com>
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Date: Thu, 11 Jun 1998 17:36:03 -0400
Message-ID: <35804DC3.55CB1496@insightdist.com> (raw)
References: <Pine.LNX.3.96.980611112320.3708A-100000@proxy>
Jose',
I got row versioning working with the "xmin" field. Since it is a system column, and
automatically updates, you would not need triggers all over the place on every table.
I made it a datasource option called "Row Versioning".
It works well with Access except for two minor caveats:
1) The driver has to report the 'xmin' field in SQLColumns. There is no way around
that I can see. Access, thus displays it. Users can of course hide the column if they
hate looking at it. And Access won't let you type into this field which is good.
2) You have to create an '=' operator for the xid type on the postgres side since one
does not already exist. I have the code to do it if you are interested (it is very
small). For 6.4, we would make sure this operator is added.
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: byronn@insightdist.com, sferac@bo.nettuno.it
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
In-Reply-To: <35804DC3.55CB1496@insightdist.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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