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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: remove tablespace for primary key (*not* by drop/recreate constraint)
Дата
Msg-id CAKFQuwaCfLjPv1UxfpkQUgN1Fh1AuZS=nHWXWKX5t-=U+9qfBg@mail.gmail.com
обсуждение исходный текст
Ответ на remove tablespace for primary key (*not* by drop/recreate constraint)  (Emi Lu <emilu@encs.concordia.ca>)
Ответы Re: remove tablespace for primary key (*not* by drop/recreate constraint)  (Emi Lu <emilu@encs.concordia.ca>)
Список 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 по дате отправления:

Предыдущее
От: Emi Lu
Дата:
Сообщение: remove tablespace for primary key (*not* by drop/recreate constraint)
Следующее
От: Emi Lu
Дата:
Сообщение: Re: remove tablespace for primary key (*not* by drop/recreate constraint)