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

--

--

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

--

--

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

--

CREATE FUNCTION rm_query_view(query_view regclass, 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.drop_relation(view_, force := true)

		-- force: needed because some query-view-relations depend on others

	FROM query_relations(query_view) view_

	;

END;

$$;

--

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

--

COMMENT ON FUNCTION rm_query_view(query_view regclass, schema_anchor anyelement) IS '

removes all DB objects related to a particular validations query

usage:

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

idempotent

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

';

--