Bernd wrote: > I found nothing on the SQLite website stating that R*Tree tables don't > support foreign key constraints but apparently they don't. Is this > a limitation of virtual tables in general or is there something I > missed?
When you execute "CREATE VIRTUAL TABLE t USING xxx(...)", any text written between the parentheses is passed to the virtual table module, which can do anything it wants with it. Typcially, what the virtual table module actually does with this text is either - passing it unchanged to SQLite to create an actual table, and layering its own features on top; or - parsing it, and implementing its own features. The R-tree virtual table module uses the second option, but it looks at the provided column names only to determine the names and number of columns in the R-tree. Therefore, foreign keys are not available in R-trees. Regards, Clemens _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
