Postgres Pro
Downloads
Home   >   mailing lists

Re: remove tablespace for primary key (*not* by drop/recreate constraint) - Mailing list pgsql-sql

From David G. Johnston
Subject Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Date
Msg-id CAKFQuwb9MYyyQxOFp5QDc1wjQjsZOPJ964KujvRkTFB1VPgM=g@mail.gmail.com
Whole thread Raw
In response to Re: remove tablespace for primary key (*not* by drop/recreate constraint)  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: remove tablespace for primary key (*not* by drop/recreate constraint)  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view
On Thu, Jun 4, 2015 at 2:35 PM, Emi Lu <emilu@encs.concordia.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.

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Next
From: Emi Lu
Date:
Subject: Re: remove tablespace for primary key (*not* by drop/recreate constraint)