Horton

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

Hannu Krosing <hannu@trust.ee>

View thread View on postgr.es
From: Hannu <hannu@trust.ee>
To: Byron Nikolaidis <byronn@insightdist.com>, interfaces postgres <pgsql-interfaces@postgreSQL.org>
Date: 1998-06-12T07:45:38Z
Lists: pgsql-sql 
Byron Nikolaidis wrote:
> 
> Hi,
...
> 
> I have tested other types besides timestamps, like int4, and they seem
> to work fine as a versioning column.  So, we could use the postgres
> 'xmin' column, if we displayed it in SQLColumns.  It seems to always
> update so you wouldn't have to worry about a trigger.  I'm not sure what
> end-users would think about seeing these ugly columns in Access?  Any
> thoughts about that?

Is'nt there some way in ODBC to return some kind of _system_ columns, 
like there are system tables ?

I think that PostgreSQL is not the only database that has system columns 

Hannu