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 | CAKFQuwb9MYyyQxOFp5QDc1wjQjsZOPJ964KujvRkTFB1VPgM=g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: 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,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 по дате отправления: