I wouldn't say anything about views - from my POV there's no much harm in supporting cross-database views other than possible user confusion (personally I don't know why it was decided to not support this). But concerning foreign keys: how do you think SQLite is supposed to enforce foreign key when other database is not attached or when you attach another database with the same alias that have table with the same name but with completely different data?
Pavel On Wed, Jan 20, 2010 at 10:33 AM, Tiberio, Sylvain <sylvain.tibe...@eads.com> wrote: > Hi, > I remark some effects if I use a main database with other attached database > (ATTACH command): > - I cannot create view in main database that select columns from main > database and attached database. > - There is no foreign key constraints control is the foreign key is on an > attached database table. > Is there any think to do to be able to do that? Do I forget something? > > Regards, > > Sylvain > > > _______________________________________________ > 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
