ON UPDATE CASCADE is probably not needed (based on column names)

Copy SQL

select  constraint_name, foreign_schema, foreign_table, af.attname as foreign_column_name, target_schema, target_table, at.attname as target_column_name, update_compensating_action
from (select 
(select nspname from pg_namespace where oid=m.relnamespace) as foreign_schema,
m.relname as foreign_table, 
m.oid as foreign_table_oid,
unnest(o.confkey) AS foreign_col,
(select nspname from pg_namespace where oid=c.relnamespace) as target_schema,
c.relname as target_table,
c.oid as target_table_oid,
unnest(o.conkey) AS target_col,
o.confupdtype,
case when confupdtype='a' then 'ON UPDATE NO ACTION' 
when confupdtype='r' then 'ON UPDATE RESTRICT' 
when confupdtype='c' then 'ON UPDATE CASCADE' 
when confupdtype='n' then 'ON UPDATE SET NULL' 
when confupdtype='d' then 'ON UPDATE SET DEFAULT' end as update_compensating_action,
o.conname as constraint_name
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_class m on m.oid = o.confrelid
where o.contype = 'f' and o.conrelid in (select oid from pg_class c where c.relkind = 'r')) f
inner join pg_attribute af on f.foreign_col = af.attnum and f.foreign_table_oid = af.attrelid and af.attisdropped = false
inner join pg_attribute at on f.target_col = at.attnum and f.target_table_oid = at.attrelid and at.attisdropped = false
AND (af.attname~*'_id$'  OR af.attname~*'^(id)_')
AND confupdtype='c'
ORDER BY target_schema, target_table, target_column_name, foreign_schema, foreign_table, foreign_column_name;