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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Table drop that fails ... "No such file or directory"
Дата
Msg-id 200001072105.QAA02790@candle.pha.pa.us
обсуждение исходный текст
Ответ на Table drop that fails ... "No such file or directory"  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: [HACKERS] Table drop that fails ... "No such file or directory"  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
> 
> Just has a support call where the client couldn't drop a table, giving him
> a 'No such file or directory' error...yet a \d showed him that the table
> existed...
> 
> To "fix" the problem, we got him to shutdown his server, touch the file
> that it says is missing, bring the server back up and then drop
> it...which, of course, succeeded...
> 
> But...does it make sense to error-out in this case?  The user wants to get
> rid of the table, the table is already gone physically, just not
> virtually...so why not just get rid of the virtual entries also?

It shows something very strange happened to him.  We don't want this
kind of thing to just happen.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: [HACKERS] [Fwd: Re: First Major Open Source Database]
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] Table drop that fails ... "No such file or directory"