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)
|
| Список | pgsql-sql |
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 по дате отправления: