Sequences not moved to new tablespace

From: Guillaume Drolet <droletguillaume(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Sequences not moved to new tablespace
Date: 2015-02-23 18:08:57
Message-ID: CAOkiyv7VFz6en74C7Q9UL6sLxXtraoPz1=Yrp=OFGVXKVE1RFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-02-23 19:07:47 Re: Sequences not moved to new tablespace
Previous Message Dave Cramer 2015-02-23 16:57:47 Re: [GENERAL] SQL solution for my JDBC timezone issue