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

On Thu, Jun 4, 2015 at 12:41 PM, Emi Lu <emilu(at)encs(dot)concordia(dot)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.

http://www.postgresql.org/docs/8.3/interactive/sql-altertable.html

Reading about tablespaces may help you as well.

​http://www.postgresql.org/docs/8.3/static/manage-ag-tablespaces.html
http://www.postgresql.org/docs/9.4/static/manage-ag-tablespaces.html

David J.