Update mass postgree na base

pgsql.sql

DO $$
DECLARE 
    kc record;
	ik record;
BEGIN 
    RAISE NOTICE 'inicio...';
    FOR kc IN SELECT * FROM kit_correios kc WHERE id_ref in (12, 45)  LOOP
		RAISE NOTICE 'Verificando kit id = % id_ref % volumes %', kc.id_kit_correio, kc.id_ref, kc.qt_volumes;
		
		FOR ik IN SELECT * FROM informacoes_kit ik WHERE id_kit_correio = kc.id_kit_correio  LOOP
			RAISE NOTICE ' kit id = % % peso % algura % largura % comprimento %', ik.id_kit_correio, kc.ds_kit_correio,  ik.nr_peso, ik.nr_altura, ik.nr_largura, ik.nr_comprimento;
		END LOOP;	
		delete from informacoes_kit ik WHERE id_kit_correio = kc.id_kit_correio; 
		IF (kc.id_ref = 12) THEN
    		RAISE NOTICE '  kit %/% => %', kc.id_kit_correio, kc.id_ref, kc.ds_kit_correio;
			INSERT INTO informacoes_kit(nr_peso, nr_altura, nr_largura, nr_comprimento, id_kit_correio) VALUES (4976, 12, 69, 70, kc.id_kit_correio );
			UPDATE kit_correios SET qt_volumes = 1 WHERE id_kit_correio = kc.id_kit_correio; 
		ELSE
			RAISE NOTICE '  kit %/% => %', kc.id_kit_correio, kc.id_ref, kc.ds_kit_correio;
			INSERT INTO informacoes_kit(nr_peso, nr_altura, nr_largura, nr_comprimento, id_kit_correio) VALUES (4288, 12, 69, 70, kc.id_kit_correio );
			UPDATE kit_correios SET qt_volumes = 1 WHERE id_kit_correio = kc.id_kit_correio; 
		END IF;	
    END LOOP;
    RAISE NOTICE 'fim';
	
END; $$;