Skip site navigation (1) Skip section navigation (2)

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

From: Hannu <hannu(at)trust(dot)ee>
To: Byron Nikolaidis <byronn(at)insightdist(dot)com>, interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Date: 1998-06-12 07:45:38
Message-ID: 3580DCA2.6ED9826E@trust.ee (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-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

In response to

Responses

pgsql-interfaces by date

Next:From: Jose' Soares Da SilvaDate: 1998-06-12 10:18:01
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Previous:From: MatthewDate: 1998-06-11 21:56:30
Subject: crypt compile problem

pgsql-sql by date

Next:From: Yingpling LuDate: 1998-06-12 08:30:53
Subject: how to bulky-copy data in postgreSql
Previous:From: Byron NikolaidisDate: 1998-06-11 21:36:03
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group