Hello.

  What follows puzzles me.  Either there's something I don't
  understand, or something is wrong.

dhcp-179(niall)7: sqlite3
SQLite version 3.8.5 2014-08-15 22:37:57
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> PRAGMA foreign_keys=on;
sqlite> PRAGMA foreign_keys;
1
sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
COMMIT;
sqlite> ^D
dhcp-179(niall)8:

  I'ld have expected the foreign_keys pragma setting to have been
  preserved.

  The version shown is currently bundled with Apple's OSX Yosemite.
  I've checked subsequent release history for changes and not found
  any of relevance.

  Thanks in anticipation for any enlightenment.

  Best regards,
  Niall O'Reilly
  
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to