Hi, I found a bug in the .genfkey functionality:
If a foreign key constraint references a table with a quoted table name, the .genfkey command will fail on that constraint. Example: create table "t.3"(c1 primary key); create table t13(c1, foreign key(c1) references "t.3"(c1)); .genfkey yields: Error in table t13: foreign key columns do not exist I looked at the code in shell.c but I could not find the right place to fix this yet. Does anyone have a suggestion on fixing this bug? Thomas -- Dipl.-Ing. Thomas Henlich Liebigstr. 38, 01187 Dresden tel.: +49 [0]351 4712357 mobil: +49 [0]175 1723884 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users