Table drop that fails ... "No such file or directory" - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Table drop that fails ... "No such file or directory"
Date
Msg-id Pine.BSF.4.21.0001071640510.18498-100000@thelab.hub.org
Whole thread Raw
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?

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




pgsql-hackers by date:

Previous
From: Don Baccus
Date:
Subject: Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: [HACKERS] [Fwd: Re: First Major Open Source Database]