On Nov 14, 2009, at 11:34 PM, 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?
It is as intended. From elsewhere in the documentation: "It is not possible to enable or disable foreign key constraints in the middle of a multi-statement transaction (when SQLite is not in autocommit mode). Attempting to do so does not return an error; it simply has no effect." http://www.sqlite.org/foreignkeys.html#fk_enable Dan. > > Regards > - Uwe > > -- > Chaos, panic & disorder - my work here is done. > > Jabber usan...@jabber.ccc.de > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
