Sequences not moved to new tablespace

Поиск
Список
Период
Сортировка
От Guillaume Drolet
Тема Sequences not moved to new tablespace
Дата
Msg-id CAOkiyv7VFz6en74C7Q9UL6sLxXtraoPz1=Yrp=OFGVXKVE1RFw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Sequences not moved to new tablespace
Re: Sequences not moved to new tablespace
Re: Sequences not moved to new tablespace
Список pgsql-general
Дерево обсуждения
Hello,

I moved all my tables and indexes from one tablespace to pg_default using

ALTER TABLE ... SET TABLESPACE pg_default;
ALTER INDEX ... SET TABLESPACE pg_default;

Some 2500 files were moved to pg_default but 461 files remain in the tablespace and so I cannot drop it.

When I query, for example:

SELECT oid, relname, relkind FROM pg_catalog.pg_class
WHERE oid IN (943602, 2650968, 2650971);

I see that most of these files are sequences. Why didn't they get moved and how can I move them to pg_default (and all other remaining files) so that I can drop the tablespace?

Thanks!

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