Skip site navigation (1) Skip section navigation (2)

Re: I saw a table that wasn't there

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tom(dot)Bakken" <Tom(dot)Bakken(at)tx(dot)usda(dot)gov>
Cc: Postgres User Group <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: I saw a table that wasn't there
Date: 2001-05-04 18:44:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
"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.


			regards, tom lane

In response to

pgsql-odbc by date

Next:From: Tom.BakkenDate: 2001-05-04 19:03:53
Subject: Re: MS Access97 Postgres ODBC problems
Previous:From: Tom.BakkenDate: 2001-05-04 18:33:27
Subject: Re: I saw a table that wasn't there

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group