Thanks you SImon. I see this is because the version of sqlite3 I have does not support foreign keys.
I am running OS X 10.6.8 and sqlite3 comes with the OS. Does anyone know where I can get a version of sqlite3 for OS X that does support foreign keys? It would have to be a compiled binary since I don't access to compilers (or the skills to use them). Thanks, Pete On Tue, Apr 3, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > Message: 5 > Date: Mon, 2 Apr 2012 17:58:28 +0100 > From: Simon Slavin <slav...@bigfraud.org> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] Foreign Key Problems > Message-ID: <922a3407-7604-4f64-87bc-07221c066...@bigfraud.org> > Content-Type: text/plain; charset=us-ascii > > > On 2 Apr 2012, at 5:56pm, Pete <p...@mollysrevenge.com> wrote: > > > 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. > > <http://sqlite.org/foreignkeys.html> > > "This document describes the support for SQL foreign key constraints > introduced in SQLite version 3.6.19." > > Simon. > -- 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
