Re: [sqlite] Question concerning foreign keys across databases

On 18 Aug 2010, at 9:54pm, Stephan Wehner wrote: > So attaching the file1 before creating the table in file2 > is going to fail? (Then sqlite would know about the {texts} table) The ATTACH command is a bit of a misnomer: it doesn't do anything to the database files. It affects a particular

Re: [sqlite] Question concerning foreign keys across databases

Hi Pavel, I think I guess that I understand what your point is. On 2010-08-18 21:18, Pavel Ivanov wrote: > This is exactly the reason why it's not logical action: SQLite will > check constraint only in those places where it knows that something is > changed and constraint can be violated. And it

Re: [sqlite] Question concerning foreign keys across databases

> In either case the insertion would > fail, since it can only be checked when it happens and it probably will > not be checked again afterwards. This is exactly the reason why it's not logical action: SQLite will check constraint only in those places where it knows that something is changed and

Re: [sqlite] Question concerning foreign keys across databases

Hello Pavel, thanks for your reply. On 2010-08-18 20:39, Pavel Ivanov wrote: >> Summary: how can I use foreign keys across database boundaries? Is it at >> all possible? > > No. It's logically incorrect action, so it's impossible. If you want > consistency of your tables to be automatically

Re: [sqlite] Question concerning foreign keys across databases

On Wed, Aug 18, 2010 at 1:39 PM, Pavel Ivanov wrote: >> Summary: how can I use foreign keys across database boundaries? Is it at >> all possible? > > No. It's logically incorrect action, so it's impossible. If you want > consistency of your tables to be automatically checked

Re: [sqlite] Question concerning foreign keys across databases

> Summary: how can I use foreign keys across database boundaries? Is it at > all possible? No. It's logically incorrect action, so it's impossible. If you want consistency of your tables to be automatically checked by database engine you need to allow that engine to see those tables at all times.

[sqlite] Question concerning foreign keys across databases

Hello, when trying to use foreign keys I'm running into a problem. It could be that I hit some general limitation, but then again the error that I'm seeing could also be issued if the database with the table of the referenced foreign key is not attached. Here's what I'm trying to do. I have