Tiberio, Sylvain <sylvain.tibe...@eads.com> wrote: > About "cross-database foreign key constraints": I agree with you that > attached database can be dettached or changed. So as it is not > possible to > create the foreign key constraint with no attached database (because > parent > table doesn't exist), I can imagine that SQLite doesn't allow to > detach > database when foreign key constraints exist on it.
And how precisely do you expect SQLite to pull that off? How it is going to stop you from, say, opening a separate connection to one of these databases (and never attaching the other), possibly from a different process? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users