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

--

--

-- Name: FUNCTION rm_all_queries(schema varchar(255), schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

--

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

--

CREATE FUNCTION rm_all_queries(schema text DEFAULT NULL::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` to the current function */

BEGIN

	PERFORM util.use_schema(schema_anchor);

	PERFORM rm_query_view(view_, schema_anchor)

	FROM validation_views(schema) view_

	;

END;

$$;

--

-- Name: FUNCTION rm_all_queries(schema text, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -

--

COMMENT ON FUNCTION rm_all_queries(schema text, schema_anchor anyelement) IS '

removes all validations queries in a schema, or in all schemas

usage:

SELECT public_validations.rm_all_queries(''datasource'');

idempotent

schema: if NULL, operates on all schemas

schema_anchor: identifies this function''s schema. should be left as the default.

';

--