On 1 Oct 2014, at 7:25am, lchis...@paradise.net.nz wrote: > Any database which has had any maintenance done on its views using any GUI or > CLI tool could manifest this scenario, and I think it should explicitly > documented as fixing it is non-trivial.
Nice catch. It may be possible to fix the shell tool by having it construct a dependency graph of entities (tables, indexes, views, triggers) and use that to decide in what order to dump the entities. Otherwise, yes, there's a problem with the .dump command and the problem should be documented. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users