Re: I saw a table that wasn't there

"Tom.Bakken" <Tom.Bakken@tx.usda.gov> writes:
> Here's what transpired:

> infosystems=> drop table outreach;
> ERROR:  mdopen: couldn't open outreach_outreach_id_key: No such file or
> directory

> This was unexpected.  Apprarently a key sequence was still floating around out
> there. I tried the following:

No, an index.  Indexes on the table have to be dropped too, and just
like the table, a rolled-back delete would already have deleted the
physical file.  Anyway, you figured out the right recovery method.

> I realize I need to upgrade to 7.1 and already have plans to within the next
> week or two.

Good.

            regards, tom lane