Received: from diligence.com (www3.diligence.com [206.252.234.248]) by hub.org (8.10.1/8.10.1) with SMTP id e8LISIs25837 for ; Thu, 21 Sep 2000 14:28:18 -0400 (EDT) Received: (qmail 5074 invoked from network); 21 Sep 2000 18:34:08 -0000 Received: from ns2.diligence.com (HELO al) (192.168.0.1) by pdc.diligence.com with SMTP; 21 Sep 2000 18:34:08 -0000 Message-Id: <4.2.0.58.20000921122251.00a4aa00@mail.diligence.com> X-Sender: tuckun@mail.diligence.com X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.0.58 Date: Thu, 21 Sep 2000 12:28:56 -0600 To: pgsql-interfaces@postgresql.org From: Tim Uckun Subject: Errors attaching tables to access. In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200009/91 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? :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.