| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: Tablespace patch review |
| Date: | 2004-06-19 08:26:15 |
| Message-ID: | 40D3F8A7.6000109@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-06-19 08:28:14 | Re: Cannot initdb in cvs tip |
| Previous Message | Christopher Kings-Lynne | 2004-06-19 08:24:32 | Re: pgsql-server: Tablespaces. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Pflug | 2004-06-19 09:17:54 | Re: Tablespace patch review |
| Previous Message | Dave Page | 2004-06-19 08:16:47 | Re: Tablespace patch review |