Update of /cvsroot/monetdb/sql/src/server
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv15614
Modified Files:
sql_schema.mx
Log Message:
If you drop a constraint like a primary key make sure there are no dependencies
on it... ;)
U sql_schema.mx
Index: sql_schema.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_schema.mx,v
retrieving revision 1.160
retrieving revision 1.161
diff -u -d -r1.160 -r1.161
--- sql_schema.mx 23 Dec 2008 10:30:07 -0000 1.160
+++ sql_schema.mx 27 Dec 2008 16:42:06 -0000 1.161
@@ -1685,6 +1685,8 @@
assert(l->h->next->type == type_int);
if ((key = mvc_bind_key(sql, ss, kname )) == NULL)
return sql_error(sql, 02, "cannot drop unknown
constraint %s\n", kname);
+ if (!drop_action && mvc_check_dependency(sql, key->base.id,
KEY_DEPENDENCY, NULL))
+ return sql_error(sql, 02, "unable to drop constraint %s
(there are database objects which depend on it)\n", key->base.name);
mvc_drop_key(sql, ss, key, drop_action);
res = stmt_none();
} break;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
