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

--

--

-- Name: FUNCTION rename_query_view(from_ regclass, to_ varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

CREATE FUNCTION rename_query_view(from_ regclass, to_ text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS void

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

BEGIN

	EXECUTE util.mk_use_own_schema(schema_anchor);

	PERFORM util.rename_relation(view_,

		new_query_view_relation_name(util.name(from_), to_, util.name(view_)))

	FROM query_relations(from_) view_

	;

END;

$$;

--

-- Name: FUNCTION rename_query_view(from_ regclass, to_ text, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON FUNCTION rename_query_view(from_ regclass, to_ text, schema_anchor anyelement) IS '

renames all DB objects related to a particular validations query

usage:

SELECT public_validations.rename_query_view(''public_validations._view_name'');

idempotent

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

';

--