U++ forum: Welcome to the forum

Re: SQLite and foreign keys [message #41292 is a reply to message #40977]

Mon, 25 November 2013 20:05

mirek
Messages: 13976
Registered: November 2005

Ultimate Member

wimpie wrote on Wed, 16 October 2013 20:28

Hello,

I am using SQLite, with a Schema with a few tables with references and I noticed I could delete rows in one table which were used in another.
After some digging I noticed in Sqlite3Schema.h the REFERENCES*** macro's are not defined.

First I wondered why, but after reading Sqlite doc's I think it's because it doesn't allow adding constraints to an existing table. Am I right?

Actually, it is rather because nobody bothered so far to implement it Smile

In fact, the issue is in RM for 2 years already:

http://www.ultimatepp.org/redmine/issues/172

I did not know there is problem with adding references later, if that is true, it really is kind of problem...

Mirek

Report message to a moderator