On Sat, Dec 27, 2008 at 05:08:39PM +0000, Romulo Goncalves wrote: > Update of /cvsroot/monetdb/sql/src/server > In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv19272 > > Modified Files: > Tag: Nov2008 > sql_schema.mx > Log Message: > It seems it is also broken in the stable... > If you drop a constraint like a primary key make sure there are no > dependencies on it... > > Note: Do not propagate this check in... it was already done in the current > branch...
if the changes are identical (i.e., made using cvs commands), propagation will notice this and silently accept the identical changes (i.e., not try to do them again). see also `man cvs` and pages 8-16 (in particular pages 13-15) of http://homepages.cwi.nl/~manegold/Presentations/MonetDBdevTTT.pdf Stefan > > U sql_schema.mx > Index: sql_schema.mx > =================================================================== > RCS file: /cvsroot/monetdb/sql/src/server/sql_schema.mx,v > retrieving revision 1.152.2.1 > retrieving revision 1.152.2.2 > diff -u -d -r1.152.2.1 -r1.152.2.2 > --- sql_schema.mx 14 Nov 2008 13:48:40 -0000 1.152.2.1 > +++ sql_schema.mx 27 Dec 2008 17:08:37 -0000 1.152.2.2 > @@ -1695,6 +1695,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 > > -- | Dr. Stefan Manegold | mailto:[email protected] | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | ------------------------------------------------------------------------------ _______________________________________________ Monetdb-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
