On 02/23/2015 10:08 AM, Guillaume Drolet wrote:
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?
Well round file my previous suggestion. Just tried it and it did not work.
Thanks!
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
