Francisco J Reyes <fran@natserv.net> writes:
> I also wonder if the syntax of the current create DB won't have to be
> changed once tablespaces are created.
I'd be inclined to remove the WITH LOCATION option the instant we have
an adequate tablespace substitute. It's such an ugly, messy, unsafe
way to do things --- depending on environment variables is bad news.
There are things I'm willing to keep around in the name of backward
compatibility, but this isn't one of them.
It's probably true that some other WITH options would have to be added
to CREATE DATABASE (and/or ALTER DATABASE) instead. For instance, I'd
imagine that we'd want to be able to specify a default tablespace for
a database; perhaps separate defaults for its tables and indexes.
regards, tom lane