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
|
Список | 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 по дате отправления: