Skip to content

Commit 71f8833

Browse files
committed
Do not repack unlogged tables (close #71)
1 parent 1b5fd1a commit 71f8833

File tree

1 file changed

+1
-0
lines changed

1 file changed

+1
-0
lines changed

lib/pg_repack.sql.in

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -208,6 +208,7 @@ CREATE VIEW repack.tables AS
208208
LEFT JOIN pg_namespace N ON N.oid = R.relnamespace
209209
LEFT JOIN pg_tablespace S ON S.oid = R.reltablespace
210210
WHERE R.relkind = 'r'
211+
AND R.relpersistence = 'p'
211212
AND N.nspname NOT IN ('pg_catalog', 'information_schema')
212213
AND N.nspname NOT LIKE E'pg\\_temp\\_%';
213214

0 commit comments

Comments
 (0)