On Sat, 19 Jun 2004, Tom Lane wrote: > [ switching to pghackers for wider comment ] > > Christopher Kings-Lynne <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org