Sry, was a bit confused You are right :-) Of course FOREIGN KEY makes no sense in a column const. ...
Pavel Ivanov schrieb: > According to http://www.sqlite.org/lang_createtable.html you can > mention foreign-key-clause (starting with REFERENCES) as > column-constraint. Why it doesn't work for you? > > Pavel > > On Wed, Nov 25, 2009 at 10:33 AM, Jan <janus...@gmx.net> wrote: >> Hi, >> >> I am testing the new fk support in my db. Currently I have *column >> constraints* for fk that were parsed by genfkey to create triggers. >> >> Simply adding FOREIGN KEY (column) to the column constr. seems not to >> work. But moving everything to the end of the table definition as a >> table constraint works. >> >> As far as I understand the docu is correct here (it is not possible tu >> use FOREIGN KEY in column constr.). But CHECK constraints are. Why is >> there a difference? >> >> Jan >> >> >> _______________________________________________ >> 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users