-- Name: loop_ignore_errors(text, text, anyelement); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION loop_ignore_errors(iter_sql text, loop_body_sql text, loop_type_null anyelement DEFAULT NULL::text) RETURNS void

    LANGUAGE plpgsql

    AS $$

DECLARE

	errors_ct integer = 0;

	loop_var loop_type_null%TYPE;

BEGIN

	FOR loop_var IN SELECT * FROM util.eval2set(iter_sql, loop_type_null)

	LOOP

		BEGIN

			EXECUTE loop_body_sql USING loop_var;

		EXCEPTION

		WHEN OTHERS THEN

			errors_ct = errors_ct+1;

			PERFORM util.raise_error_warning(SQLERRM);

		END;

	END LOOP;

	IF errors_ct > 0 THEN

		-- can't raise exception because this would roll back the transaction

		PERFORM util.raise_error_warning('there were '||errors_ct

			||' errors: see the WARNINGs for details');

	END IF;

END;

$$;

--