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

Errors attaching tables to access.

From: Tim Uckun <tim(at)diligence(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Errors attaching tables to access.
Date: 2000-09-21 18:28:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
I am having some trouble attaching tables from postgres 7.0.2 to access 97.

when I attemp to attach a table I sometimes get this error message. 
"Invalid field definition 'UNKNOWN' in definition of index or relation" 
this only happens on some tables including some system tables.

For some tables I can attach but when I attempt to open it  i get 'ODBC 
call Failed' and then all the data in the table whows up as #Name?

Any clues?

Tim Uckun
Due Diligence Inc.   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: Doug BudnyDate: 2000-09-21 18:38:41
Subject: RE: Replication between MS-Access and PostgreSQL
Previous:From: Chris HaasDate: 2000-09-21 16:01:57
Subject: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found

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