Re: SQLite's default ON CONFLICT algorithm

2008-08-18 Thread Gerhard Häring
egbert wrote: Yes, I know that this is off-topic, but I feel justified by sqlite3 being a builtin. The default ON CONFLICT algorithm in SQLite is ABORT. The SQLite documentation ("ON CONFLICT clause") says that when a constraint violation occurs under ABORT, no rollback is executed, so changes

SQLite's default ON CONFLICT algorithm

2008-08-18 Thread egbert
Yes, I know that this is off-topic, but I feel justified by sqlite3 being a builtin. The default ON CONFLICT algorithm in SQLite is ABORT. The SQLite documentation ("ON CONFLICT clause") says that when a constraint violation occurs under ABORT, no rollback is executed, so changes from prior comma