On 08/20/2011 12:50 AM, Duquette, William H (318K) wrote: > > On 8/19/11 10:44 AM, "Boris Kolpackov"<bo...@codesynthesis.com> wrote: > >> Hi William, >> >> "Duquette, William H (318K)"<william.h.duque...@jpl.nasa.gov> writes: >> >>> On 8/19/11 10:18 AM, "Boris Kolpackov"<bo...@codesynthesis.com> wrote: >>> >>> BEGIN TRANSACTION; >>> DROP TABLE employer; >>> DROP TABLE employee; >>> COMMIT; >>> >>> According to the sqlite docs, dropping a table when FK constraints are >>> enabled does an implicit "DELETE FROM" first. >>> so how can there still be FK constraint violations? >>> Am I missing something? >> If so, then that would be the two of us. Though I think this is a bug >> in SQLite. > > I think it might be.
It is. Now fixed in the trunk. http://www.sqlite.org/src/info/b1d3a2e531 Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
