Re: I saw a table that wasn't there

"Tom.Bakken" <Tom(dot)Bakken(at)tx(dot)usda(dot)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