On Sep 10, 2016 2:54 AM, "John McMahon" <li...@jspect.fastmail.fm> wrote: > > On 08/09/2016 10:09, Bob McFarlane wrote: >> >> Please reply if you sent this. Thanks. >> > > Hmm, looks like a fishing exercise to me. Same message in several threads. > > This reply only to mailing list.
It's an anti-spam measure. Most spam will either not get the auto generated message, or if it is a forgery the victim has a chance to disavow the content. I think it is too heavy handed a technique personally, but to each their own. I sent the sender an email letting him know that his anti-spam system was spamming the crap out of the list and he fixed it. Easy peasy. > > John > >> >> >> >> >> -----Original Message----- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On >> Behalf Of Richard Hipp >> Sent: Wednesday, September 7, 2016 7:49 PM >> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> >> Subject: Re: [sqlite] Problem with rename table >> >> On 9/6/16, Radovan Antloga <radovan.antl...@siol.net> wrote: >>> >>> Hi Richard ! >>> >>> I can't find a solution how to fix my database after I have renamed >>> table DOKUMENTI to DOKUMENTI2. >>> Table DOKUMENTI had trigger dokumenti_trigger1 and after renaming >>> table I cant execute any sql. I forgot to drop trigger first. So now I >>> always get error: >>> malformed database schema (dokumenti_trigger1) - no such table >>> main.dokumenti. >> >> >> Rename the table back to its old name? >> >> Worst case: You can drop all the triggers like this: >> >> PRAGMA writable_schema=ON; >> DELETE FROM sqlite_master WHERE type='trigger'; >> >> Then close and reopen your database, and you have no more triggers. >> The same will work for views. But if you try the above with tables or >> indexes, you'll end up with a database that fails "PRAGMA integrity_check" - >> though the corruption can be fixed with a VACUUM. >> -- >> D. Richard Hipp >> d...@sqlite.org >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> TMGID:S11411219126200001011 >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > > -- > Regards > John McMahon > li...@jspect.fastmail.fm > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
