Revision 14183
Added by Aaron Marcuse-Kubitza over 10 years ago
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
schemas/util.sql: added check_constraint__disabled(), which creates a CHECK constraint which is initially disabled