From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
---|---|
To: | Amos Bird <amosbird(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: make default TABLESPACE belong to target table. |
Date: | 2016-11-27 15:20:34 |
Message-ID: | 8be04688-d5a4-0295-794d-e9563fb75bcf@BlueTreble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 11/27/16 2:01 AM, Amos Bird wrote:
>
>> I was thinking about introducing a new GUC, named something like
>> default_index_tablespace, which would need to have at least these
>> behaviors:
>
> Should we also consider the chidren tables as mentioned by Corey?
Wouldn't point #2 handle that?
> 2. index tablespace is same as table's tablespace.
As for a magic value, based on other recent discussion the idea of "-1"
came to me, since per the docs[1] that's not a valid identifier... but
experimentation shows it's fine if you double-quote it. :/
1:
https://www.postgresql.org/docs/current/static/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)
From | Date | Subject | |
---|---|---|---|
Next Message | Amos Bird | 2016-11-27 15:39:49 | Re: make default TABLESPACE belong to target table. |
Previous Message | Jim Nasby | 2016-11-27 15:12:47 | Re: pg_config --version |