Hi, It seems that when creating a virtual table the 'IF NOT EXISTS' part is missing from the sql column in sqlite_master for the recently created table entry.
For example: sqlite> CREATE VIRTUAL TABLE IF NOT EXISTS `Mail` USING FTS4(`subject`, `body`); sqlite> SELECT `sql` FROM `sqlite_master` WHERE `name` = 'Mail'; CREATE VIRTUAL TABLE `Mail` USING FTS4(`subject`, `body`) Is this intended behaviour? Thanks, -Dany _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users