Received: from kodu.home.ee (isdn-54.uninet.ee [194.204.0.118])
	by hub.org (8.9.3/8.9.3) with ESMTP id CAA78132
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 15 Jul 1999 02:04:58 -0400 (EDT) (envelope-from hannu@trust.ee)
Received: from trust.ee (hannu@localhost [127.0.0.1])
	by kodu.home.ee (8.8.7/8.8.7) with ESMTP id JAA00494;
	Thu, 15 Jul 1999 09:14:18 +0300
Sender: hannu@kodu.home.ee
Message-ID: <378D7C3A.4682B800@trust.ee>
Date: Thu, 15 Jul 1999 09:14:18 +0300
From: Hannu Krosing <hannu@trust.ee>
Organization: Trust-O-Matic =?iso-8859-1?Q?O=DC?=
X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.2.6 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Terence Chan <kin.chan@technologist.com>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC problem
References: <000301bece81$e55664e0$9d4fb8d2@terence.cetec.com.hk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Terence Chan wrote:
> 
> I have exported a table from MS Access 97 to PG via ODBC. I can see the file
> is exported to the correct place but psql complaining the table is not
> there.

Are you sure that the file (and directories leading to it) are readable
by the 
user postgres, or whatever your backend runs as ?

As a last resort move the file to /tmp and chmod 777 it.

------
Hannu