Re: [sqlite] Inverted changesets and UNIQUE constraints

2019-08-26 Thread Daniel Kraft
Hi! On 26.08.19 14:05, Simon Slavin wrote: > On 26 Aug 2019, at 12:43pm, Dan Kennedy wrote: >> When sqlite3changeset_apply() hits a UNIQUE constraint, it puts the change >> into a "retry buffer". Then, once it has attempted all changes in the >> changeset, it goes back and retries those in the

Re: [sqlite] Inverted changesets and UNIQUE constraints

2019-08-26 Thread Simon Slavin
On 26 Aug 2019, at 12:43pm, Dan Kennedy wrote: > When sqlite3changeset_apply() hits a UNIQUE constraint, it puts the change > into a "retry buffer". Then, once it has attempted all changes in the > changeset, it goes back and retries those in the retry buffer. It keeps > retrying like this

Re: [sqlite] Inverted changesets and UNIQUE constraints

2019-08-26 Thread Dan Kennedy
On 26/8/62 15:12, Daniel Kraft wrote: Hi! I'm using the SQLite session extension to create changesets, invert them and apply them to undo previous changes in the database. (Essentially what I need to do is persistent savepoints.) This works well so far, but I recently wondered about the

[sqlite] Inverted changesets and UNIQUE constraints

2019-08-26 Thread Daniel Kraft
Hi! I'm using the SQLite session extension to create changesets, invert them and apply them to undo previous changes in the database. (Essentially what I need to do is persistent savepoints.) This works well so far, but I recently wondered about the interaction with UNIQUE constraints. In