On Fri, Apr 25, 2014 at 10:22 AM, olivier Ménard <men37...@yahoo.fr> wrote: > create table T(a primary key not null); > create table U(a references T not null); > insert into U values(4)
C:\Users\DDevienne>sqlite3 SQLite version 3.8.4.3 2014-04-03 16:53:12 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> create table T(a primary key not null); sqlite> create table U(a references T not null); sqlite> insert into U values(4); Error: FOREIGN KEY constraint failed sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users