| From: | Mike Mascari <mascarm(at)mascari(dot)com> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | The Hermit Hacker <scrappy(at)hub(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] Table drop that fails ... "No such file or directory" |
| Date: | 2000-01-08 01:11:06 |
| Message-ID: | 38768EAA.BA03AA85@mascari.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hiroshi Inoue wrote:
> > > That is the big question. We need to hear about these problems, because
> > > the represent something very strange happening. Somehow, the physical
> > > table was deleted, but it still existed in the system tables.
> >
> > Hmmm...problem is, I would think, in most cases it wouldn't be noticed
> > until a later time, this case as an example...
> >
>
> Isn't it the result of a DROP TABLE failure ?
> mdunlink() removes the base file of a relation immediately and
> the file couldn't be rollbacked in case of abort.
>
> I have already made it possible to DROP TABLE even though there
> aren't base files of relation/indexes in current tree 2 months ago.
>
> Regards.
>
> Hiroshi Inoue
>
Sounds like it was caused by DDL statements in aborted
transactions to me....
Mike (implicit commit, again) Mascari
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2000-01-08 03:00:00 | Re: [HACKERS] [Fwd: Re: First Major Open Source Database] |
| Previous Message | Hiroshi Inoue | 2000-01-07 23:41:47 | RE: [HACKERS] Table drop that fails ... "No such file or directory" |