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!
