On 15 Sep 2011, at 4:36pm, Fabio Spadaro wrote: > i just installed python 2.7.2 and the value returned by "PRAGMA > foreign_keys" is [(0,)]; Later I will try with the tables.
Can you tell whether your python installation process is installing a new version of whatever sqlite API you're using ? Depending on how it's packaged it might be part of it or it might be separate. Please do this entire sequence: Make a connection to the database. Issue "PRAGMA foreign_keys" and look at the table returned. Issue "PRAGMA foreign_keys = OFF". Issue "PRAGMA foreign_keys" and look at the table returned. Issue "PRAGMA foreign_keys = ON". Issue "PRAGMA foreign_keys" and look at the table returned. We can tell a lot by looking at the results, including whether your version was compiled without foreign key support. Note that foreign key support is always initially off. Currently you are expected to do "PRAGMA foreign_keys = ON" each time you open a database even if you have previously used foreign keys with it. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
