Andreas Pflug <pgadmin@pse-consulting.de> writes:
> Christopher Kings-Lynne wrote:
>> 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 :(
> As long as we interpret schema and database tablespace just as default
> for future object creation, hopefully not.
But his point is that we don't --- the database tablespace is not "just
a default", it is *the place* where the system catalogs are stored, as
well as where anything else with pg_class.reltablespace = 0.
I think what we have is fine for 7.5. Later on we could look at
separating the two concepts. I'm not entirely sure what to call them
however. Also it'd be less than clear just what CREATE DATABASE should
do with cases where the values are being changed.
regards, tom lane