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