> Tom already mentioned this just after committing tablespaces: 'Minor DROP
> TABLESPACE issue'
>
> http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg46540.html
>
> In fact, I see that you contributed to the thread :-).
>
> I think the result of the thread was to make the error message a little
> more helpful and that adding empty files to represent schemas would be a
> pain (think WAL and name collision).
Ah, I must have been in a dream state.
The other thing we need are these two commands:
ALTER DATABASE foo SET TABLESPACE spc;
ALTER SCHEMA foo SET TABLESPACE spc;
I think these should not be considered new features but essential
functionality left out of the original patch.
Chris