There are - to one relationships. E.g. X1 (deleted), X2 (inserted), Y1 (updated FK from X1 to X2).
Andrus On Feb 18, 2011, at 12:25 AM, Aristedes Maniatis wrote: > On 18/02/11 12:53 AM, Andrus Adamchik wrote: >> Then there are cases that don't have correct ordering at all. Usually this >> involves cyclic relationships. I don't have an example handy, but IIRC we >> discussed that some time ago. > > Would it make sense to perform all deletes before all inserts? Or are there > situations where that is not correct? > > Ari > > -- > --------------------------> > Aristedes Maniatis > GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A >
