Re: [sqlite] [EXTERNAL] Re: SQLITE bug

2017-09-04 Thread Richard Damon
Depends on why you are restoring a backup (what data got corrupted). Even if you are restoring a full backup of all the tables, you still need to restore the ID fields rather than using the auto increment value or you still break the relationships. On 9/4/17 2:42 AM, Hick Gunter wrote: Are yo

Re: [sqlite] [EXTERNAL] Re: SQLITE bug

2017-09-03 Thread Hick Gunter
Are you really proposing to restore just one or a selected set of tables from a backup of the database? What state does a transaction that touches one or more tables that are restored and one or more tables that aren't go to? It can't be "commited" because some data is not in the final state, an