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 <[email protected]> wrote: > > On 8 Nov 2012, at 5:27pm, [email protected] 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
