It appears that any table beginning "sqlite_" provokes "SQL error: object name reserved for internal use: sqlite_?" where ? is the text following "sqlite_"
The articles you have referenced appear to be discussions of possible future enhancements. Rgds, Simon 2008/6/13 Alexey Pechnikov <[EMAIL PROTECTED]>: > Hello! > > How can I create table sqlite_extensions? I read > http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions > and try > > sqlite> create table sqlite_extensions ( > ...> load INT, -- the order in which the extension > ...> -- is to be loaded/initialized. > ...> -- lowest number loads first. > ...> -- if tied, order is alphabetical by name. > ...> > ...> name TEXT, -- name of the extension shared library. > ...> -- Note: both the path and suffix is NOT to be included > in name. > ...> > ...> init TEXT, -- name of the shared library entry point init > function. > ...> -- optional, may be null. > ...> -- if null, the entry point function will be > constructed > ...> -- from name. > ...> > ...> fini TEXT -- name of the shared library entry point unload > function. > ...> -- shared library unloading will be in the reverse > order > ...> -- of loading. > ...> -- optional, may be null. > ...> ); > SQL error: object name reserved for internal use: sqlite_extensions > > > sqlite> insert into sqlite_extensions (name) values ('libSqliteRtree'); > SQL error: no such table: sqlite_extensions > > > And I found this page > http://article.gmane.org/gmane.comp.db.sqlite.general/29803 > about table sqlite_shared_libs, but > > sqlite> CREATE TABLE sqlite_shared_libs( > ...> architecture TEXT, > ...> library BLOB > ...> ); > SQL error: object name reserved for internal use: sqlite_shared_libs > sqlite> select * from sqlite_shared_libs; > SQL error: no such table: sqlite_shared_libs > > > > Best regards, Alexey. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
