2015-02-23 14:14 GMT-05:00 Adrian Klaver <adrian.kla...@aklaver.com>:
> 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. So, anybody else have some piece of advice on this? > >> Thanks! >> >> > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
