-- Name: force_recreate(text, text[]); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION force_recreate(cmd text, users text[] DEFAULT NULL::text[]) RETURNS void

    LANGUAGE plpgsql

    AS $_$

DECLARE

	PG_EXCEPTION_DETAIL text;

	recreate_users_cmd text = util.save_drop_views(users);

BEGIN

	PERFORM util.eval(cmd);

	PERFORM util.eval(recreate_users_cmd);

EXCEPTION

WHEN dependent_objects_still_exist THEN

	IF users IS NOT NULL THEN RAISE; END IF; -- save_drop_views() didn't fix it

	GET STACKED DIAGNOSTICS PG_EXCEPTION_DETAIL = PG_EXCEPTION_DETAIL;

	users = array(SELECT * FROM util.regexp_matches_group(

		PG_EXCEPTION_DETAIL, '(?m)^view (.*) depends on table .*$'));

	IF util.is_empty(users) THEN RAISE; END IF;

	PERFORM util.force_recreate(cmd, users);

END;

$_$;

--

-- Name: FUNCTION force_recreate(cmd text, users text[]); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION force_recreate(cmd text, users text[]) IS 'idempotent

users: not necessary to provide this because it will be autopopulated';

--