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

--

CREATE FUNCTION force_update_view(view_ text, query text) RETURNS void

    LANGUAGE plpgsql STRICT

    AS $_$

DECLARE

	mk_view text = $$CREATE OR REPLACE VIEW $$||view_||$$ AS

$$||query;

BEGIN

	EXECUTE mk_view;

EXCEPTION

WHEN invalid_table_definition THEN

	IF SQLERRM = 'cannot drop columns from view' THEN

		EXECUTE $$DROP VIEW $$||view_||$$ CASCADE$$;

		EXECUTE mk_view;

	ELSE RAISE USING ERRCODE = SQLSTATE, MESSAGE = SQLERRM;

	END IF;

END;

$_$;

--

-- Name: FUNCTION force_update_view(view_ text, query text); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION force_update_view(view_ text, query text) IS 'idempotent';

--