On Sat, Oct 19, 2013 at 9:17 PM, Bogdan Ureche <bogdan...@gmail.com> wrote:
> What would be a good way to extract metadata information about temporary > triggers? If there are multiple tables with the same name in main and temp > databases (or even attached databases), I could not find a way to determine > on which table a temporary trigger was created by examining the available > information in sqlite_temp_master, unless the table name was qualified in > the trigger creation SQL. > ... > And yes, I know these scenarios can be avoided simply by qualifying the > table name in the trigger declaration - which would change the DDL to > "CREATE TRIGGER tr1 after insert on <db>.t1..." - but that is beside the > point. It is not always possible to be in control of the queries the users > may be executing. > The binding is undefined and may shift at unpredictable times. In other words: don't do that. We have updated the documentation at ( http://www.sqlite.org/draft/lang_createtrigger.html#temptrig) to make this clear. Who are your users that you allow them arbitrary control over the DDL and yet you feel the need to protect them from their own actions? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users