Selectively block TRUNCATE only for persistent tables

UNLOGGED or TEMPORARY tables may be truncated without restriction.