On 28 Nov 2010, at 5:51pm, Chris Wolf wrote: > Simon Slavin wrote: >> Which version of SQLite are you using ? > > It's 3.7.3 on MacOs 10.5 but I have two versions on my Mac - 3.4.0 > which comes out-of-the > box and a dev version I'm hacking around with, 3.7.3. I just forgot to > qualify the shell name with "./".
Heh. I win again. > Sorry about that. It works with 3.7.3 and pragma foreign_keys=on You're doing it right. I have found at least one thing in OS X 10.5 that upgrading the out-of-the-box version of SQLite breaks. (I thought it would: I was testing it so I could write documentation.) It's fixed in 10.6 but it seems the standard advice about SQLite and OS X is correct: keep two separate copies. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

