This might be the script to run one Edwin's merge fix is released:
-- Deactivate all archives that belong to merged users.
-- Set archive ito DELETING and disable it.
-- This assumes all jobs are complete.
update archive
set
status = 1,
enabled = FALSE
from
person p
where
p.id = a.owner
and p.merged is not null
and a.status = 0;
;
This might be the script to run one Edwin's merge fix is released:
-- Deactivate all archives that belong to merged users.
-- Set archive ito DELETING and disable it.
-- This assumes all jobs are complete.
update archive
set
status = 1,
enabled = FALSE
from
person p
where
p.id = a.owner
and p.merged is not null
and a.status = 0;
;