Received: from kss.net.au ([203.41.122.41]) by hub.org (8.10.1/8.10.1) with ESMTP id e7359MG81390 for ; Thu, 3 Aug 2000 01:09:22 -0400 (EDT) Received: from kss.net.au (coco [10.10.1.9]) by kss.net.au (8.8.7/8.8.7) with ESMTP id PAA31931 for ; Thu, 3 Aug 2000 15:09:17 +1000 Message-ID: <3988FF7C.F023BCC@kss.net.au> Date: Thu, 03 Aug 2000 15:13:32 +1000 From: Carolyn Lu Wong Organization: Kwiker Software Solutions X-Mailer: Mozilla 4.7 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: What is happening? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/16 I was trying to dump data, drop then recreate table, and import data back to the table. There were errors during the process and the transaction was not committed. The table is there when I do '\d' and the table definition is there. However, I can't drop table nor select from this table. I always get the following error: ERROR: mdopen: couldn't open accounts: No such file or directory.