Re: remove tablespace for primary key (*not* by drop/recreate constraint)

On 06/04/2015 11:35 AM, Emi Lu 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?

set tablespace pg_default

>
> Thanks
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com