On 9/20/17, petern <peter.nichvolo...@gmail.com> wrote: > What are the drawbacks to allowing triggers on system tables? Is this an > arbitrary restriction?
System tables are sometimes modified directly, without going through the usual DELETE/INSERT/UPDATE logic. In order to support triggers on system tables, logic to check for and invoke triggers would need to be added to every place in the code that modifies system tables. This is doable in theory, but is error prone, generates a lot of extra code that is rarely used but takes up memory space on embedded devices and must still be maintained, and is of questionable utility. -- 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
