From: Tim Uckun <tim@diligence.com>
To: pgsql-interfaces@postgreSQL.org
Subject: Linking views and tables to access.
Date: Tue, 01 Aug 2000 15:27:24 -0600
Message-ID: <4.2.0.58.20000801152147.00a4c9b0@diligence.com> (raw)
In-Reply-To: <398703E5.10395.47F9ACE@localhost>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tim@diligence.com
Subject: Re: Linking views and tables to access.
In-Reply-To: <4.2.0.58.20000801152147.00a4c9b0@diligence.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox