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

Linking views and tables to access.

From: Tim Uckun <tim(at)diligence(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Linking views and tables to access.
Date: 2000-08-01 21:27:24
Message-ID: 4.2.0.58.20000801152147.00a4c9b0@diligence.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Hello.

I am having a couple of problems. One is that when I attempt to link SOME 
tables to access I get an error messages about an index containing a non 
existing field (an empty string). The other is that when I attempt to link 
a view as a table I get the following error.

ERROR: system column xmin not available - vievname is a view (#1)

I strongly suspect that the first error is due to the fact that I changed 
the NAMEDATALEN in the source when I compiled postgres. I suspect that the 
ODBC driver is not expecting a large string and is getting one. Could the 
second problem be related? Also is it possible to compile the ODBC drivers 
with a similar DEFINE?

Right now the NAMEDATALEN is set to 64. Although this is still small 
compared to access It's a more sane option then 32 for me.

:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/   Americas Background 
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered 
the risks of a bad hire.


In response to

pgsql-interfaces by date

Next:From: Ken J. WrightDate: 2000-08-01 23:57:16
Subject: Re: Function sequence error with ODBCExpress
Previous:From: Joel BurtonDate: 2000-08-01 21:07:49
Subject: RE: Postgres connect with Access

pgsql-general by date

Next:From: Mike SearsDate: 2000-08-01 22:26:36
Subject: Re: random() function produces wrong range
Previous:From: Joel BurtonDate: 2000-08-01 21:07:49
Subject: RE: Postgres connect with Access

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