Re: [PATCHES] Tablespace patch review

[ 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