-- Name: check_constraint_disable(check_constraint_def); Type: FUNCTION; Schema: util; Owner: -

--

CREATE FUNCTION check_constraint_disable(constraint_def check_constraint_def) RETURNS void

    LANGUAGE sql

    AS $$

SELECT util.check_constraint_replace((constraint_def.constraint_,

util.check_constraint_expr_disable(constraint_def.expr)))

$$;

--

-- Name: FUNCTION check_constraint_disable(constraint_def check_constraint_def); Type: COMMENT; Schema: util; Owner: -

--

COMMENT ON FUNCTION check_constraint_disable(constraint_def check_constraint_def) IS '

also accepts a util.table_item via implicit cast

usage:

SELECT util.check_constraint_disable((table, constraint_name)::util.table_item);

**WARNING**: *not* idempotent, unlike util.check_constraint_enable()

';

--