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.
- Re: [SQL] What is happening? Carolyn Lu Wong
- Re: [SQL] What is happening? The Hermit Hacker
- Re: [SQL] What is happening? Tom Lane