SELECT util.force_recreate($$

-- 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;

	restore_views_info util.restore_views_info;

BEGIN

	restore_views_info = util.save_drop_views(users);

	PERFORM util.eval(cmd);

	PERFORM util.restore_views(restore_views_info);

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 [[:lower:]]+ .*$'));

		-- will be in forward dependency order

	PERFORM util.debug_print_var('PG_EXCEPTION_DETAIL', PG_EXCEPTION_DETAIL);

	PERFORM util.debug_print_var('users', users);

	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 '

usage:

SELECT util.force_recreate($$

-- trigger the dependent_objects_still_exist exception

DROP VIEW schemas.main_view; -- *not* CASCADE; it must trigger an exception

CREATE VIEW schemas.main_view AS _;

-- manually restore views that need to be updated for the changes

CREATE VIEW schemas.dependent_view AS _;

$$);

idempotent

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

';

--

SELECT util.force_recreate($$

SELECT util.force_recreate($$

SELECT util.force_recreate($$