Project

General

Profile

« Previous | Next » 

Revision 14183

schemas/util.sql: added check_constraint__disabled(), which creates a CHECK constraint which is initially disabled

View differences:

trunk/schemas/util.sql
875 875

  
876 876

  
877 877
--
878
-- Name: check_constraint__disabled(check_constraint_def); Type: FUNCTION; Schema: util; Owner: -
879
--
880

  
881
CREATE FUNCTION check_constraint__disabled(constraint_def check_constraint_def) RETURNS void
882
    LANGUAGE sql
883
    AS $$
884
SELECT util.check_constraint_disable(constraint_def) -- auto-create
885
$$;
886

  
887

  
888
--
889
-- Name: FUNCTION check_constraint__disabled(constraint_def check_constraint_def); Type: COMMENT; Schema: util; Owner: -
890
--
891

  
892
COMMENT ON FUNCTION check_constraint__disabled(constraint_def check_constraint_def) IS '
893
creates a CHECK constraint which is initially disabled
894

  
895
**WARNING**: *not* idempotent
896
';
897

  
898

  
899
--
878 900
-- Name: check_constraint_def(table_item); Type: FUNCTION; Schema: util; Owner: -
879 901
--
880 902

  

Also available in: Unified diff