Table drop that fails ... "No such file or directory"

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Table drop that fails ... "No such file or directory"
Дата
Msg-id Pine.BSF.4.21.0001071640510.18498-100000@thelab.hub.org
обсуждение исходный текст
Ответы Re: [HACKERS] Table drop that fails ... "No such file or directory"  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 




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

Предыдущее
От: Don Baccus
Дата:
Сообщение: Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL
Следующее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: [HACKERS] [Fwd: Re: First Major Open Source Database]