SQLite3 in Python 2.7 Rejecting Foreign Key Insert

Jussi Piitulainen jpiitula at ling.helsinki.fi
Sun Nov 23 10:40:57 CET 2014


Chris Angelico writes:
> On Sun, Nov 23, 2014 at 7:21 PM, Frank Millman wrote:
>
> > To enable them, add the following -
> >
> > pragma foreign_keys = on;
> >
> > It works for me.
> 
> Thanks, I went poking around briefly but didn't find that pragma.

I didn't notice a pointer to the relevant documentation in this thread
yet. So here, and in the rest of that page:

    <http://www.sqlite.org/foreignkeys.html#fk_enable>



More information about the Python-list mailing list