Re: bug in DROP TABLESPACE

> The latter is relatively trivial as long as you interpret it as just
> changing the default TS for tables created later in that schema.
> (On the other hand, you can fake that with a simple UPDATE to
> pg_namespace, so I'm not sure it qualifies as a "must have".)
>
> The former is a real mess since it would require moving some of the
> system catalogs. (At least the nailed-in-cache ones, but I'm not sure
> we've yet determined which ones *have* to be in the database's default
> tablespace.) It'll be fairly entertaining to move pg_class in
> particular, but I doubt you can build such a thing out of the available
> spare parts at all.
>
> My vote would be to postpone any such patch to 7.6 (or 8.1 as the case
> may be), because it's a nontrivial addition of functionality and we had
> no prototype as of July 1.

It seems to me that we have mixed up two concepts: the tablespaces that
a database is IN and the default tablespaces for any schemas created in
that tablespace. This will probably cause trouble further down the track :(

Chris