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

--

--

-- Name: FUNCTION rematerialize_out_view(datasource_schema varchar(255), out_view regclass); Type: COMMENT; Schema: public_validations; Owner: -

--

--

SET search_path = public_validations, pg_catalog;

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

--

CREATE FUNCTION rematerialize_out_view(datasource_schema text, out_view regclass) 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) */

DECLARE

	out_table text = '_out_'||util.name(out_view);

BEGIN

	/* datasource_schema must be 1st in the search_path so that queries can use

	it in current_schema, and so that out_table is created in the datasource's

	schema */

	PERFORM set_config('search_path', util.mk_search_path(datasource_schema),

		true);

	PERFORM util.rematerialize_view(out_table, out_view);

	RETURN out_table;

END;

$$;

--

-- Name: FUNCTION rematerialize_out_view(datasource_schema text, out_view regclass); Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON FUNCTION rematerialize_out_view(datasource_schema text, out_view regclass) IS '

helper function; use rematerialize_out_view(in_view) instead

usage:

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

idempotent, but repeats action each time

';

SET search_path = public, pg_catalog;

--