Re: Tablespace patch review

Tom Lane wrote:

>[ 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.
>  
>

CREATE .... TABLESPACE DEFAULT with default as keyword seems reasonable 
too, with default -> pg_default.

I could think of cases where temporary schemas should go to a different 
tablespace, but AFAICS since these are created implicitely there's no 
way to redirect them. Maybe an additional attribute in pg_database for a 
default temp tablespace is desirable?

Regards,
Andreas