From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | emilu(at)encs(dot)concordia(dot)ca |
Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |
Date: | 2015-06-04 18:51:15 |
Message-ID: | CAKFQuwb9MYyyQxOFp5QDc1wjQjsZOPJ964KujvRkTFB1VPgM=g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thu, Jun 4, 2015 at 2:35 PM, Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> Hello,
>
> to remove tablespace for primary key please?
>>
>> For example, z1 (c1 text) with pk_z1 PRIMARY KEY (c1), tablespace "abc"
>>
>> May I know how to remove tablespace(set tablespace to empty for z1)?
>>
>
> It doesn't make sense to "remove" a tablespace...the best you can do
> is change a table's (and its related indexes) tablespace
>
>
> from one to another.
>
> If "ALTER TABLE ... SET TABLESPACE ..." doesn't accomplish your goal
> you will need to explain yourself better.
>
>
> Want to SET tablespace = '' for primary key but not table. Tried alter
> index ... set tablespace='', but empty does not work?
>
>
So, what you want to do is place the primary key index back onto the
default tablespace while the table resides on a different tablespace?
Does this work?
ALTER INDEX ... SET TABLESPACE pg_default;
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Emi Lu | 2015-06-05 13:33:05 | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |
Previous Message | Adrian Klaver | 2015-06-04 18:50:37 | Re: remove tablespace for primary key (*not* by drop/recreate constraint) |