Re: [PATCHES] Tablespace patch review

On Sat, 19 Jun 2004, Tom Lane wrote:

> [ switching to pghackers for wider comment ]
>
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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.

Great idea. I recognised that default was reserved and was using "default"
in testing. I meant to raise this for discussion when I submitted the
patch. pg_default/pg_global are great.

Gavin