If you want, you can verify automatically that all the FK columns have a type matching the referenced columns by using (and tweaking) an old tool whose name is 'genfkey' (see http://www.sqlite.org/faq.html#q22 but the 'readme' link is broken). Regards.
On Thu, Nov 8, 2012 at 6:29 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 8 Nov 2012, at 5:27pm, stahl...@dbs.uni-hannover.de wrote: > > > But inferring the FK's type from the referenced PK would cause > applications > > which rely on the FK's type affinity being 'none' to be broken, no? > > At this sort of level of bug-compatibility, you have to say "Will not be > fixed until SQLite4." > > Simon. > _______________________________________________ > 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