Re: [sqlite] foreign keys across database boundaries

2012-08-27 Thread Kees Nuyt 
On Mon, 27 Aug 2012 11:44:18 +0300, Baruch Burstein
 wrote:

> Can foreign keys or triggers be set between ATTACHed database tables? If
> so, is there any other type of statment that doesn't work across ATTACH
> boundaries?

Foreign keys, triggers and views cannot cross ATTACH boundaries.

-- 
Regards,

Kees Nuyt

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

Re: [sqlite] foreign keys across database boundaries

2012-08-27 Thread Dan Kennedy 

On 08/27/2012 03:44 PM, Baruch Burstein wrote:

Can foreign keys or triggers be set between ATTACHed database tables?


No. They can not.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] foreign keys across database boundaries

2012-08-27 Thread Baruch Burstein 
Can foreign keys or triggers be set between ATTACHed database tables? If
so, is there any other type of statment that doesn't work across ATTACH
boundaries?

-- 
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users