> ---- Mensaje original ---- > De: Richard Hipp <drh at sqlite.org> >Fecha: 4/11/2015 23:23 (GMT+01:00) >Para: SQLite mailing list <sqlite-users at mailinglists.sqlite.org> >Asunto: Re: [sqlite] Problem when upgrading from FTS3/4 to FTS5 modules
>Here is a hack. >Let the name of your FTS3 table be "xyzzy" >(1) Invoke "PRAGMA writable_schema=ON". (Read the documentation about >the dangers thereof. Do not complain if something goes wrong and you >corrupt your database.) >(2) Run "DELETE FROM sqlite_master WHERE name='xyzzy';" >(3) Set "PRAGMA writable_schema=OFF" again. >(4) Run the following: > >DROP TABLE IF EXISTS xyzzy_content; >DROP TABLE IF EXISTS xyzzy_segments; >DROP TABLE IF EXISTS xyzzy_segdir; >DROP TABLE IF EXISTS xyzzy_docsize; >DROP TABLE IF EXISTS xyzzy_stat; Thanks a lot That tricky worked fine. -- Adolfo
