The table is moved to tablespace pg _default from database default tablespace

[vut12]

pg_repack 1.4.8
this problem is observed if set new default tablespace to database.

# ALTER DATABASE postgres SET TABLESPACE tbs_new;
# SELECT d.datname, tbs.spcname FROM pg_database d 
    JOIN pg_tablespace tbs ON d.dattablespace=tbs.oid WHERE d.datname='postgres';
 datname  |  spcname
----------+------------
 postgres | tbs_new
(1 row)

# CREATE TABLE table_tbs_new (id int4 PRIMARY KEY);
# SELECT tablename, tablespace FROM pg_tables WHERE tablename='table_tbs_new';
   tablename   | tablespace
---------------+------------
 table_tbs_new |
(1 row)

Now table "table_tbs_new" in tablespace "tbs_new". Run pg_repack , assuming the tablespace doesn't change.

pg_repack -D -d postgres -t public.table_tbs_new

# SELECT tablename, tablespace FROM pg_tables WHERE tablename='table_tbs_new';
   tablename   | tablespace
---------------+------------
 table_tbs_new | pg_default
(1 row)

after pg_repack table moved from tbs_new to pg_default

[za-arthur]

I guess this is because pg_default is hard coded in repack.tables view:

pg_repack/lib/pg_repack.sql.in

Line 248 in ddd5f14

coalesce(quote_ident(S.spcname), 'pg_default') as tablespace_orig,

[za-arthur]

This was fixed within #368