-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 raf wrote: >> printing error messages to stderr rather than ignoring >> them shoulden't require an overhaul.
It does though. You need to fix every place where an error can be detected and take an appropriate action. One extra printf is not the entire solution. >>> If you are only getting busy errors >>> then try the .timeout command with a nice large value such as 15000. > >> but that's my point. >> i'm not getting any errors. >> it's just failing silently. Ok, if the shell internally is getting busy errors (and doing nothing about it) then setting the timeout should help. I suspect that setting the timeout will make your problem go away, especially if it has a large value. >>> You may want to consider writing your own dump command that works >>> exactly the way you want. If you are generating textual output then you >>> basically just call sqlite3_exec as appropriate. > >> that seems like a waste of effort when there is already >> a dump command in sqlite3. The point is that you can format the output exactly how you want (quoting rules, handling of nulls) and error handling. You can also make the abort handle the way you want should some data already be printed. For example a non-zero exit may be sufficient, or you may want to flush the output, emit a rollback command, and then have a non-zero exit. >> i would much rather add some >> print statements to sqlite3 itself so that others could >> benefit as well. That is fine too :-) >> would a patch to do this be likely to be accepted? DRH would need to chime in on that. Generally patches are accepted provided they don't break existing code (ie other people using SQLite), benefit the majority of users and don't have a high cost (memory, CPU, code maintenance etc). You will also need to follow "Contributed Code" at http://www.sqlite.org/copyright.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkkVKOYACgkQmOOfHg372QTWFgCfSaABW/A9YE9jTijF016xs4Yq FAkAoJDEalsAaKQFnDu7RX8YCtrpWjC2 =z/8f -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users