Re: Why can't I drop a tablespace?

Tom Lane wrote:
> "Phil Endecott" <spam_from_pgsql_list@chezphil.org> writes:
>> Thanks Laurenz. I was looking at the source for "alter table set
>> tablespace" yesterday trying to work out what is supposed to happen.
>> There is a comment at tablecmds.c line 3989: "Thanks to the magic of
>> MVCC, an error anywhere along the way rolls back the whole operation;
>> we don't have to do anything special to clean up." But I guess that
>> creating an entirely new file on a different filesystem is an
>> exception to that.
>
> No, but PANIC'ing during commit is :-(.  Ordinarily the files created by a
> failed transaction would be removed during transaction cleanup, but we
> did not reach that code.  So these were left behind, but the table's
> original files in the original tablespace should be undamaged.

OK, I've removed them - fingers crossed!

Thanks to everyone who replied for your advice.


Regards, Phil.