-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hamish Allan wrote:
> The workaround suggested on the tracker ("Couldn't you just do a 'drop
> table if exists' first?") does not make sense, as it ensures the
> emptiness of the table rather than just its existence.
Virtual tables do not directly have any storage - they are just a row in
sqlite_master.
The implementation may do something. For example FTS3 creates 3 real tables
behind the scenes. Virtual tables that map to a CSV file generally do not
delete the CSV file when the virtual table is dropped.
What this means is that for some cases it is perfectly harmless to drop the
virtual table as it has no side effects. In other cases (eg FTS3) then you
would lose its behind the scenes tables.
Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAktwgYgACgkQmOOfHg372QTbGACfZE/GuQxo+Te2IXJ/gnzs5Het
x1QAn0EJPFpFjvyroPnP84TPkbvHP8mO
=8ClE
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
