Re: how to handle circular references if DB enforces ref. integrity

2001-11-20 Thread Heikki Tuuri
Hi! >Hi! > >> "Arjen" == Arjen G Lentz <[EMAIL PROTECTED]> writes: > > > >>> The problem is, how would you add a new bus and a new driver to the >>> database? Whichever one is added first, you're going to get an error >>> because its counterpart doesn't exist yet, violating referential integ

Re: how to handle circular references if DB enforces ref. integrity

2001-11-20 Thread Michael Widenius
Hi! > "Arjen" == Arjen G Lentz <[EMAIL PROTECTED]> writes: >> The problem is, how would you add a new bus and a new driver to the >> database? Whichever one is added first, you're going to get an error >> because its counterpart doesn't exist yet, violating referential integrity. >> >>

Re: how to handle circular references if DB enforces ref. integrity

2001-11-18 Thread Arjen G. Lentz
Hi Bennett, - Original Message - From: "Bennett Haselton" <[EMAIL PROTECTED]> > In a database that enforced referential integrity, if you say that a field > in one table is a foreign key referencing another table, then any value in > the foreign key field in the first table must referenc

Re: how to handle circular references if DB enforces ref. integrity

2001-11-16 Thread Shankar Unni
Kristian Köhntopp wrote: > Bennett Haselton wrote: > >>The problem is, how would you add a new bus and a new driver to the >>database? Whichever one is added first, you're going to get an error >>because its counterpart doesn't exist yet, violating referential integrity. >> > > I was under the

Re: how to handle circular references if DB enforces ref. integrity

2001-11-16 Thread Kristian Köhntopp
Bennett Haselton wrote: > The problem is, how would you add a new bus and a new driver to the > database? Whichever one is added first, you're going to get an error > because its counterpart doesn't exist yet, violating referential integrity. I was under the impression that databases enforced re