Re: [HACKERS] Table drop that fails ... "No such file or directory"

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