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 CAKFQuwaCfLjPv1UxfpkQUgN1Fh1AuZS=nHWXWKX5t-=U+9qfBg@mail.gmail.com
Whole thread Raw
In response to 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)
List pgsql-sql
On Thu, Jun 4, 2015 at 12:41 PM, Emi Lu <emilu@encs.concordia.ca> wrote:
Hello list,

Due to there are lots of foreign key dependencies, would prefer not to drop/create for primary key. Is there other way(s) for psql8.3

Version 8.3 is no longer supported.​
 
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.


Reading about tablespaces may help you as well.


David J.

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: 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)