<br />The last portion of my original post got edited out by mistake.<br /><br />The tests I ran were on version 9.1.3,
runningFedora 14, kernel 2.6.35.14-106.fc14-i686.<br /><br />It seems to me that DROP TABLESPACE should check to see if
thereare references in the system catalog to the tablespace before dropping it, not just that the tablespace itself is
empty. That way it would have thrown an error when I tried to drop the tablespace.<br /><br />A somewhat separate issue
iswhat to do when a tablespace is inaccessible, such as due to a disk failure. The thread on -general that prompted my
testswas a relatively easy one to suggest how to repair, because the lost tablespace only had indexes in it. But
that'snot exactly a -hackers issue, more of a question of better backup protocols.<br /> --<br />Mike Nolan<br />
