*** 20,25 ****
--- 20,28 ----
the virtual table implementation. They cannot be added separately
using CREATE INDEX statements.)
*: You cannot run ALTER TABLE commands against a virtual table.
+ *: Virtual tables cannot be used in a database that makes use
+ of the {link: /capi3ref.html#sqlite3_enable_shared_cache shared cache}
+ feature.
Particular virtual table implementations might impose additional
constraints. For example, some virtual implementations might
***************
*** 218,223 ****
--- 221,232 ----
to implement various features of the virtual table.
Details on what each of these methods do are provided
on the VirtualTableMethods page.
+
+ The virtual table mechanism assumes that each database connection
+ keeps its own copy of the database schema. Hence, the
+ virtual table mechanism cannot be used in a database that has
+ shared cache enabled. The sqlite3_create_module() interface will
+ return an error if the shared cache feature is enabled.
*Creating New Virtual Tables*
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|