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

Поиск
Список
Период
Сортировка
От Emi Lu
Тема remove tablespace for primary key (*not* by drop/recreate constraint)
Дата
Msg-id 55707FAA.8060204@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 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)?

Thanks a lot!




В списке pgsql-sql по дате отправления:

Предыдущее
От: Skylar Thompson
Дата:
Сообщение: Re: PG and Temporal
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: remove tablespace for primary key (*not* by drop/recreate constraint)