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.
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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
