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

Reply via email to