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

Поиск
Список
Период
Сортировка
От Mike Mascari
Тема Re: [HACKERS] Table drop that fails ... "No such file or directory"
Дата
Msg-id 38768EAA.BA03AA85@mascari.com
обсуждение исходный текст
Ответ на RE: [HACKERS] Table drop that fails ... "No such file or directory"  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Table drop that fails ... "No such file or directory"
Следующее
От: Thomas Lockhart
Дата:
Сообщение: Re: [HACKERS] [Fwd: Re: First Major Open Source Database]