-- Name: remake_diff_table(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

--

-- Name: FUNCTION remake_diff_table(in_view regclass, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

--

-- Name: remake_diff_table(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -

--

CREATE FUNCTION remake_diff_table(in_view regclass, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS regclass

    LANGUAGE plpgsql

    SET search_path TO pg_temp

    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

	in_table regclass;

	out_table regclass;

	diff_table text = util.qual_name(util.schema(in_view),

		'_diff_'||util.name(in_view));

BEGIN

	EXECUTE util.mk_use_own_schema(schema_anchor);

	in_table = rematerialize_in_view(in_view);

	out_table = rematerialize_out_view(in_view);

	PERFORM util.inherit(in_table, out_table);

	PERFORM util.rematerialize_query(diff_table, $$

SELECT * FROM util.diff(

  $$||quote_nullable(in_table)||$$

, $$||quote_nullable(out_table)||$$

, NULL::$$||out_table||$$)

$$);

	RETURN diff_table;

END;

$_$;

--

-- Name: FUNCTION remake_diff_table(in_view regclass, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON FUNCTION remake_diff_table(in_view regclass, schema_anchor anyelement) IS '

usage:

SELECT public_validations.remake_diff_table(''datasource._view_name'') AS diff_table;

idempotent, but repeats action each time

schema_anchor: identifies which schema to use. should be left as the default value.

';

--