Re: [HACKERS] Table drop that fails ... "No such file or directory" - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Table drop that fails ... "No such file or directory"
Date
Msg-id 200001072105.QAA02790@candle.pha.pa.us
Whole thread Raw
In response to Table drop that fails ... "No such file or directory"  (The Hermit Hacker <scrappy@hub.org>)
Responses Re: [HACKERS] Table drop that fails ... "No such file or directory"
List 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 by date:

Previous
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: [HACKERS] [Fwd: Re: First Major Open Source Database]
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Table drop that fails ... "No such file or directory"