Re: problem/bug in drop tablespace?
| От | Michael Nolan |
|---|---|
| Тема | Re: problem/bug in drop tablespace? |
| Дата | |
| Msg-id | CAOzAqu+tZTjORkGDZEUYpEVY0xf4TMBn2XBbv2=8fZ5Na-qEVg@mail.gmail.com обсуждение исходный текст |
| Ответ на | problem/bug in drop tablespace? (Michael Nolan <htfoot@gmail.com>) |
| Список | pgsql-hackers |
<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 />
В списке pgsql-hackers по дате отправления: