On Fri, May 11, 2012 at 10:03 PM, Tom Lane
<tgl@sss.pgh.pa.us> wrote:
Well, the question to me is exactly how much good it will do to stop
deletion of the pg_tablespace entry, if the underlying files are gone.
I'm having a hard time getting excited about expending cycles on that.
There could be multiple reasons why the underlying files are not there, such as a filesystem that isn't currently mounted for some reason.
It seems prudent to throw an error on drop tablespace if there are references to that tablespace in the catalog, or perhaps require a 'force' clause to override any errors, but it probably isn't something most DBAs would run into very often.
Thanks for figuring it out, Tom.
--
MIke Nolan