-- Name: remake_diff_tables(varchar(255), anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

-- Name: remake_diff_tables(text, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION remake_diff_tables(schema text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

    LANGUAGE plpgsql

    AS $$

/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime

changes of search_path (schema elements are bound at inline time rather than

runtime) */

/* function option search_path is needed to limit the effects of

`SET LOCAL search_path` (mk_set_search_path()) to the current function */

DECLARE

	errors_ct integer = 0;

	in_view regclass;

BEGIN

	EXECUTE util.mk_use_own_schema(schema_anchor);

	FOR in_view IN SELECT * FROM validation_views(schema)

	LOOP

		BEGIN

			PERFORM remake_diff_table(in_view, schema_anchor);

		EXCEPTION

		WHEN OTHERS THEN

			errors_ct = errors_ct+1;

			PERFORM util.raise_notice(SQLERRM);

		END;

	END LOOP;

	IF errors_ct > 0 THEN

		RAISE internal_error USING MESSAGE =

			errors_ct||' queries had errors. please see the NOTICEs for details.';

	END IF;

END;

$$;

--