test with

WITH deleted AS (
    DELETE FROM tbl_xxx WHERE....
    returning *
)
INSERT INTO tbl_xxx .......
SELECT * FROM deleted;