Revision 14154
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 886 | 886 |
|
| 887 | 887 |
|
| 888 | 888 |
-- |
| 889 |
-- Name: check_constraint_drop(table_item); Type: FUNCTION; Schema: util; Owner: - |
|
| 890 |
-- |
|
| 891 |
|
|
| 892 |
CREATE FUNCTION check_constraint_drop(constraint_ table_item) RETURNS void |
|
| 893 |
LANGUAGE sql |
|
| 894 |
AS $_$ |
|
| 895 |
SELECT util.eval($$ALTER TABLE $$||constraint_.table_||$$ DROP CONSTRAINT $$|| |
|
| 896 |
quote_ident(constraint_.name)) |
|
| 897 |
$_$; |
|
| 898 |
|
|
| 899 |
|
|
| 900 |
-- |
|
| 889 | 901 |
-- Name: check_constraint_expr_enable(text); Type: FUNCTION; Schema: util; Owner: - |
| 890 | 902 |
-- |
| 891 | 903 |
|
Also available in: Unified diff
schemas/util.sql: added check_constraint_drop()