| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Heaven <steve(at)thornet(dot)co(dot)uk> |
| Cc: | pgsql-general(at)hub(dot)org |
| Subject: | Re: 'Zombie' tables |
| Date: | 2000-07-07 16:40:19 |
| Message-ID: | 10614.962988019@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve Heaven <steve(at)thornet(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randall Parker | 2000-07-07 16:45:09 | JDBC: Encrypted connections? SSL? |
| Previous Message | Travis Bauer | 2000-07-07 16:27:08 | view permissions problem - featuer or bug? |