[ switching to pghackers for wider comment ]
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> 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.
Seems like a reasonable suggestion to me. Any objections?
BTW, another argument for this is that "default" is a reserved word.
I'd already noticed in testing that CREATE TABLE ... TABLESPACE default
doesn't work unless you double-quote "default". Calling it pg_default
would avoid that annoyance.
regards, tom lane