-- Name: recreate_view(regclass, text, text); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION recreate_view(view_ regclass, view_query text, dependent_view_changes text DEFAULT ''::text) RETURNS void

    LANGUAGE sql

    AS $_$

SELECT util.recreate($$

CREATE VIEW $$||$1||$$ AS 

$$||$2||$$

;

$$||util.mk_set_relation_metadata($1)||$$

-- manually restore views that need to be updated for the changes

$$||$3||$$

$$);

$_$;

--

-- Name: FUNCTION recreate_view(view_ regclass, view_query text, dependent_view_changes text); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION recreate_view(view_ regclass, view_query text, dependent_view_changes text) IS '

usage:

SELECT util.recreate_view(''schema.main_view'', $$

SELECT __

$$, $$

CREATE VIEW schema.dependent_view AS 

__;

$$||util.mk_set_relation_metadata(''schema.dependent_view'')||$$

$$);

idempotent

';

--