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

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

From: Byron Nikolaidis <byronn(at)insightdist(dot)com>
To: hannu(at)trust(dot)ee
Cc: interfaces postgres <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Date: 1998-06-12 13:53:35
Message-ID: 358132DF.2262873F@insightdist.com (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-sql

Hannu wrote:

> 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
>

Yes, the 'pseudo' column attribute in SQLSpecialColumns does this.  I am
setting it for the xmin field, but Access never even bothers to look at it (it
never binds the column or does GetData).  It is only interested in the column
name!?!

You would think that you could report system columns like 'xmin' just in
SQLSpecialColumns and not have to also specify them in SQLColumns.  But as I
said, if I don't also specify the column in SQLColumns, Access barfs with the
message "Table TMP%#MAU@ already exists." when I try to open the table.  The
linking phase works fine though.

It doesn't make much sense.

If you have any ideas what the heck that message means, PLEASE TELL ME!!!!

Byron




In response to

pgsql-interfaces by date

Next:From: Byron NikolaidisDate: 1998-06-12 13:57:22
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Previous:From: David HartwigDate: 1998-06-12 13:46:43
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

pgsql-sql by date

Next:From: Byron NikolaidisDate: 1998-06-12 13:57:22
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs
Previous:From: David HartwigDate: 1998-06-12 13:46:43
Subject: Re: [INTERFACES] Re: M$-Access'97 and TIMESTAMPs

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