Received: from mail2.teleport.com (mail2.teleport.com [192.108.254.43])
	by hub.org (8.9.1/8.9.1) with SMTP id LAA23975
	for <pgsql-interfaces@postgreSQL.org>;
	Sat, 23 Jan 1999 11:40:02 -0500 (EST)
	(envelope-from gregg@gbcomputers.com)
Received: (qmail 4674 invoked from network); 23 Jan 1999 16:40:00 -0000
Received: from i48-15-04.pdx.du.teleport.com (HELO gbcomputers.com)
	(216.26.5.132)
	by mail2.teleport.com with SMTP; 23 Jan 1999 16:40:00 -0000
Message-ID: <36A9FB59.78D77383@gbcomputers.com>
Date: Sat, 23 Jan 1999 08:39:53 -0800
From: Gregg Berkholtz <gregg@gbcomputers.com>
Organization: GB Computers
X-Mailer: Mozilla 4.5 [en] (Win95; U)
X-Accept-Language: en
MIME-Version: 1.0
To: Postgres interface list <pgsql-interfaces@postgreSQL.org>
Subject: Errors on indexes
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I keep getting this error after trying to link an existing Access 97
front-end to a PostgreSQL backend:

"Invalid field definition 'assetID' in definition of index or
relationship."

The assetID field is a valid is a valid field name in the correct table,
there are also indexes to assetID too.

I did use the pgadmin database migration utility to migrate the data
from MS Access 97 to PostgreSQL.
My server is Slackware 3.6, Postgres 6.4.2
My workstation is running Windows95.

Any ideas?
Thanks for the help.
Gregg Berkholtz