Am Montag, den 06.12.2010, 22:13 +0000 schrieb Simon Slavin: > On 6 Dec 2010, at 10:00pm, Oliver Peters wrote: > > > [...] > > > >> The wording is not completely correct indeed. > >> In general, views, triggers, and foreign key constraints can only > >> use objects within the same schema (=database). > >> > >> That makes sense, because SQLite (and you) cannot guarantee the > >> other database file is attached when the view is used, the trigger > >> fires, or the reference is referred. > > > > I think I've to go on asking because of a lack of basic knowledge but: > > > > what is the problem to give the programmer/user the chance to decide on > > his own if he wants to use such a feature with all its included risks? > > If you allow this, there's no way to do an integrity check on the > resulting database files because users might rename or move the files > that act as the second database.
I think that depends on the context you're using sqlite. In this case I have multiple users working on one sqlitefile in a MS network and I want them to store their individual ID in there own temporary table so that a trigger can use these IDs. I don't see the danger here and if you see it I don't see the necessity to be as careful as you ;-). (Please be patient with me because I'm just a heavy user). > Also, you have to invent another > error condition for every command that might change the database, so > it can report that the command itself is fine but the required > database is not attached. I interpret that sqlite doesn't already have such an error condition. That let's me ask 2 questions: 1. what is the point against such a feature? 2. why can't I live without it (in my case I have a NOT NULL and a FOREIGN KEY constraint)? > > If you want this done, you can do it in your own code. That is impossible because I'm not a programmer (only a little awk and basic) > Or you can > rethink the mismatch between what you mean by 'database' and what > SQLite means by 'database'. The handling of data in dbs means to be very precise if I understood the lessons I've learned until now. So please give me enlightenment cause I really don't understand your last sentence. Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
