> regression=# create database foo location 'bar';
> WARNING: LOCATION is not supported anymore
> HINT: Consider using tablespaces instead.
> CREATE DATABASE
>
> and everything will go into the default tablespace. I don't really
> see how to do much better than that ...
You could create an automatically named tablespace instead of the
location...
By the way, I think that we should deny users the ability to create
tablespaces that begin with pg_. Also, the existing ones should be
pg_global and pg_default. That way, we have room to move if ever we
decide we want more system tablespaces. It also makes it easier to dump
non-system tablespaces.
Chris