regression=# create database foo location 'bar';
WARNING:  LOCATION is not supported anymore
HINT:  Consider using tablespaces instead.

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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to