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