Merge pull request #72 from j16sdiz/patch-1

schmiddy · schmiddy · commit 7238a15a9c82 · 2016-02-16T16:54:05.000-05:00
Do not repack unlogged tables (close #71)
diff --git a/lib/pg_repack.sql.in b/lib/pg_repack.sql.in
@@ -208,6 +208,7 @@ CREATE VIEW repack.tables AS
          LEFT JOIN pg_namespace N ON N.oid = R.relnamespace
          LEFT JOIN pg_tablespace S ON S.oid = R.reltablespace
    WHERE R.relkind = 'r'
+     AND R.relpersistence = 'p'
      AND N.nspname NOT IN ('pg_catalog', 'information_schema')
      AND N.nspname NOT LIKE E'pg\\_temp\\_%';
 
