Re: [sqlalchemy] SQLite Foreign Key Enforcement

2010-04-12 Thread Michael Bayer
On Apr 12, 2010, at 7:22 PM, NickPerkins wrote: > Apparently, new versions of SQLite will enforce Foreign Keys ( unlike > previous versions ), but, for the sake of backwards-compatibility, you > have to explicitly turn on foreign key enforcement by issuing: "pragma > foreign_keys=on;". > > http:

[sqlalchemy] SQLite Foreign Key Enforcement

2010-04-12 Thread NickPerkins
Apparently, new versions of SQLite will enforce Foreign Keys ( unlike previous versions ), but, for the sake of backwards-compatibility, you have to explicitly turn on foreign key enforcement by issuing: "pragma foreign_keys=on;". http://www.sqlite.org/foreignkeys.html I am new to SQLAlchemy -- h