On May 7, 2012, at 3:24 PM, Marc L. Allen wrote: > Apparently, the update is done a row at a time.
Yep, therefore the OP inquiry about DEFERRABLE INITIALLY DEFERRED for unique constraints. > Whether a row is deleted depends on whether the row being updated clashes > with a current row when adding one. Yep. Bug or feature? Looks like a bug to me, or a least a very unwelcome misfeature :/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
