On Nov 14, 2009, at 11:34 AM, Uwe Sander wrote: > Hi, > the documentation states that ALTER TABLE ... RENAME ops do not > update the > name of a referenced table if foreign_keys=off has been set > previously. This > is only true if no enclosing transaction exists, otherwise > foreign_keys=off > is ignored. Is this a bug or a misunderstnding on my side? >
The documentation failed to mention that PRAGMA foreign_keys is a no- op within a transaction. That oversight has now been corrected and will appear in the next release. http://www.sqlite.org/docsrc/vinfo/a802dbe3fbf6d0979de534d400910211b854b978 D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users