-- Name: derived_cols_remove(regclass); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION derived_cols_remove(table_ regclass) RETURNS void

    LANGUAGE sql

    AS $$

-- in reverse dependency order so nothing cascades to other derived cols

SELECT util.drop_derived_col(def.col)

FROM util.in_reverse(ARRAY(SELECT util.derived_col_defs(table_))) def

;

SELECT NULL::void; -- don't fold away functions called in previous query

$$;

--

-- Name: FUNCTION derived_cols_remove(table_ regclass); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION derived_cols_remove(table_ regclass) IS '

allows derived columns to be re-created in a different order

idempotent

';

--