On Mon, May 7, 2012 at 9:35 AM, Petite Abeille <petite.abei...@gmail.com>wrote:
> > 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 :/ > Call it whichever you want. SQLite has *always* worked this way, for reasons that go very deeply into the design. And applications exists which depends on the current behavior. So it probably isn't going to change. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
