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

>
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026