pg_strict

pig build pkg pg_strict         # 构建 RPM / DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

shared_preload_libraries = 'pg_strict';

CREATE EXTENSION pg_strict;

SET pg_strict.require_where_on_update = 'on';
SET pg_strict.require_where_on_delete = 'warn';

ALTER DATABASE postgres SET pg_strict.require_where_on_update = 'on';
ALTER ROLE app_service SET pg_strict.require_where_on_delete = 'on';
ALTER ROLE dba_admin SET pg_strict.require_where_on_update = 'off';

BEGIN;
SET LOCAL pg_strict.require_where_on_delete = 'off';
DELETE FROM temp_table;  -- 在此事务中允许
COMMIT;

SELECT pg_strict_version();           -- 扩展版本
SELECT pg_strict_config();            -- 所有设置及其值和描述

-- 以编程方式验证查询
SELECT pg_strict_check_where_clause('DELETE FROM t', 'DELETE');  -- 返回布尔值
SELECT pg_strict_validate_update('UPDATE t SET x=1');
SELECT pg_strict_validate_delete('DELETE FROM t');

-- 快速模式切换
SELECT pg_strict_enable_update();     -- 将 update 执行设为 'on'
SELECT pg_strict_warn_delete();       -- 将 delete 执行设为 'warn'
SELECT pg_strict_disable_update();    -- 将 update 执行设为 'off'