On Oct 20, 2010, at 4:47 PM, Frank Millman wrote:

> Dan Kennedy wrote:
>>
>> On Oct 20, 2010, at 3:59 PM, Frank Millman wrote:
>>
>>> Hi all
>>>
>>> I am using SQLite 3.7.2 on Fedora 10.
>>>
>>> I have multiple databases, which I can access concurrently
>> by using
>>> the
>>> 'attach' command, and then referring to each table using
>>> 'database.tablename'. It works well.
>>>
>>> Now I want to create a foreign key constraint where the
>> parent table
>>> is in
>>> one database and the child table is in another database. However,
>>> when I use
>>> the syntax 'REFERENCES database.tablename' I get a syntax error.
>>>
>>> Is it possible to do what I want?
>>
>> No. It is not.
>>
>
> Ok, thanks.
>
> Is there any chance of it being considered for a future release?

Seems quite unlikely, unfortunately.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to