On Sat, 23 Jul 2016 01:06:23 +0000 "Smith, Randall" <rsm...@qti.qualcomm.com> wrote:
> Using "REFERENCES main.Symbols" appears to be a syntax error. I think you got caught by a special case. Any kind of DRI would be hard to enforce across database boundaries. In general, if we have two databases, there's no requirement they be used together, no requirement they both be attached. Although the DBMS could conceivably implement a rule that says any constraint referencing a nonexistent (unattached) database yields False, I haven't used one that works that way. To a one, they simply prohibit schema-qualified names in DRI rules. (I suppose that's one justification for the use of triggers.) --jkl _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
