Re: Tablespace patch review - Mailing list pgsql-patches

From Christopher Kings-Lynne
Subject Re: Tablespace patch review
Date
Msg-id 40D3F8A7.6000109@familyhealth.com.au
Whole thread Raw
In response to Re: Tablespace patch review  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
> regression=# create database foo location 'bar';
> WARNING:  LOCATION is not supported anymore
> HINT:  Consider using tablespaces instead.
> CREATE DATABASE
>
> and everything will go into the default tablespace.  I don't really
> see how to do much better than that ...

You could create an automatically named tablespace instead of the
location...

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.

Chris

pgsql-patches by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Tablespace patch review
Next
From: Andreas Pflug
Date:
Subject: Re: Tablespace patch review