Re: 'Zombie' tables - Mailing list pgsql-general

From Tom Lane
Subject Re: 'Zombie' tables
Date
Msg-id 10614.962988019@sss.pgh.pa.us
Whole thread Raw
In response to 'Zombie' tables  (Steve Heaven <steve@thornet.co.uk>)
List pgsql-general
Steve Heaven <steve@thornet.co.uk> writes:
> We run 6.5.2 on a Mandrake Linux 6.1 box.
> The scripts create various temporary tables which are then later
> dropped. Occasionally the 'DROP' doesnt work properly. The file
> base/<dbname>/<tablename> gets deleted, but the entry in pg_class
> doesnt. This leads to a table that cant be dropped. (see below) The only
> way out of this that we have found is to manually copy another file to
> base/<dbname>/<zombietablename> and then drop it.

That's the standard workaround.

> Is this a bug or are we doing something wrong?

It's a bug.  Fixed in 7.0 as far as I know.

            regards, tom lane

pgsql-general by date:

Previous
From: Travis Bauer
Date:
Subject: view permissions problem - featuer or bug?
Next
From: "Randall Parker"
Date:
Subject: JDBC: Encrypted connections? SSL?