| From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
|---|---|
| To: | Carolyn Lu Wong <carolyn(at)kss(dot)net(dot)au> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: What is happening? |
| Date: | 2000-08-03 11:41:26 |
| Message-ID: | Pine.BSF.4.21.0008030840210.497-100000@thelab.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Thu, 3 Aug 2000, Carolyn Lu Wong wrote:
> 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.
what version of PostgreSQL are you running, first off ... what I've done
in the past that has been successful is to go into the
data/base/<database> directory, do a 'touch accounts' so that there is a
file there for the postgres process to unlink, and then do the drop table
...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antti Linno | 2000-08-03 13:49:34 | Extracting data by months |
| Previous Message | Karel Zak | 2000-08-03 10:39:31 | Re: a question about dates and timestamp |