> Also, it appears that the foreign_keys setting only applies for the life of > a db connection and they have to be enabled every time a db is opened. Is > that correct?
Yes, that's correct. > Do all PRAGMA settings work like that? Almost. Some of exceptions are page_size, auto_vacuum, journal_mode (at least to some extent). Pavel On Mon, Apr 2, 2012 at 12:56 PM, Pete <p...@mollysrevenge.com> wrote: > I have a couple of follow up questions on this. > > sqlite3 doesn't seem to recognise the foreign_keys PRAGMA. If I execute > "PRAGMA foreign_keys=1", I don't get an error. If I then execute "PRAGMA > foreign_keys" to get the setting, nothing is returned. If I INSERT a > record that violates the foreign key constraint, it is inserted without an > error. > > Enabling foreign keys in my application works fine and INSERTs thast > violate a fkey constraint fail. Is this a know problem with sqlite3? I'm > using version 3.6.12 on a Mac. > > Also, it appears that the foreign_keys setting only applies for the life of > a db connection and they have to be enabled every time a db is opened. Is > that correct? Do all PRAGMA settings work like that? > > Thanks, > > Pete > > On Mon, Apr 2, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > >> Message: 12 >> Date: Mon, 02 Apr 2012 15:33:20 +0700 >> From: Dan Kennedy <danielk1...@gmail.com> >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] Foreign Key Problems >> Message-ID: <4f796450.9030...@gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1; format=flowed >> >> On 04/02/2012 07:22 AM, Pete wrote: >> > I'm running into an issue with foreign keys where no matter what value I >> > supply for a child key, I get a foreign key mismatch error. Here are my >> > test tables. >> >> "foreign key mismatch" indicates a schema problem. Usually a missing >> index. See here: >> >> http://www.sqlite.org/foreignkeys.html#fk_indexes >> >> It's likely you need to create a UNIQUE index on t1.RefColumn. >> > > > > -- > Pete > Molly's Revenge <http://www.mollysrevenge.com> > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
