Received: from u1.abs.net (root@u1.abs.net [207.114.0.131])
	by hub.org (8.9.1/8.9.1) with ESMTP id OAA00702
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 24 Nov 1998 14:28:15 -0500 (EST)
	(envelope-from byronn@insightdist.com)
Received: from insightdist.com (nobody@localhost)
	by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA22595
	for pgsql-interfaces@postgreSQL.org;
	Tue, 24 Nov 1998 14:21:32 -0500 (EST)
X-Authentication-Warning: u1.abs.net: nobody set sender to
	insightdist.com!byronn using -f
Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03)
	id AA32423; Tue, 24 Nov 1998 14:09:48 -0500
Received: from byronn by ceodev (AIX 4.1/UCB 5.64/4.03)
	id AA60362; Tue, 24 Nov 1998 14:08:26 -0500
Message-Id: <365B05A3.FFCA6D23@insightdist.com>
Date: Tue, 24 Nov 1998 14:14:43 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
Mime-Version: 1.0
To: "Gilley, Charles H." <Charles.Gilley@glenayre.com>
Cc: pgsql-interfaces <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Postgresql vs. Access97, TransferDatabase
References: 
 <18D7589E9C44D21199AC00805F31B04708A089@atlanta_nt2.atlanta.glenayre.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Gilley, Charles H. wrote:

> I'm trying to move an existing access database to Postgres.
> I've tried cut/paste, export/import, all without success.  Trying the
> transfer database approach, I receive the following error:
>
>         Error creating the table; ERROR type name lookup of lo failed (#17).
>
>

You need to create the "lo" datatype in the postgres database.  See the Faq at
our website for more info.http://www.insightdist.com/psqlodbc

Byron