Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

Поиск
Список
Период
Сортировка
От Byron Nikolaidis
Тема Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Дата
Msg-id 35804DC3.55CB1496@insightdist.com
обсуждение исходный текст
Ответ на Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Ответы Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs  ("Jose' Soares Da Silva" <sferac@bo.nettuno.it>)
Список 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 по дате отправления:

Предыдущее
От: Matthew
Дата:
Сообщение: crypt compile problem
Следующее
От: Hannu
Дата:
Сообщение: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs