Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Date
Msg-id 35804DC3.55CB1496@insightdist.com
Whole thread Raw
In response to Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Responses Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
List pgsql-interfaces
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




pgsql-interfaces by date:

Previous
From: Matthew
Date:
Subject: crypt compile problem
Next
From: Hannu
Date:
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs