On 03.01.2011 13:15 CE(S)T, Drake Wilson wrote: > Quoth Yves Goergen <[email protected]>, on 2011-01-03 13:01:17 > +0100: >> So I have foreign keys from message_revision to message and the other >> way around. This obviously won't work because when defining the table >> message, the table message_revision isn't known yet. > > What do you mean? Creating two tables with circular foreign keys > works fine for me.
> In particular, if you never create table B, subsequent operations on A > may fail, but the creation succeeds and allows you to create B later. Oh, I didn't even dare executing such statements... but it really works. Enable foreign key constraints, create a table referencing a non-existent table and everything's just fine... Well, then this topic may be regarded solved. :-) -- Yves Goergen "LonelyPixel" <[email protected]> Visit my web laboratory at http://beta.unclassified.de _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
