--

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

--

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

    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) */

BEGIN

	PERFORM set_config('search_path', util.schema_esc(schema_anchor), true);

	RETURN rematerialize_out_view(datasource_schema := util.schema(in_view),

		out_view := util.qual_name(util.schema(schema_anchor),

		util.name(in_view)));

END;

$$;

--

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

--

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

usage:

SELECT public_validations.rematerialize_out_view(''datasource._view_name'') AS out_table;

idempotent, but repeats action each time

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

';