Comment 1 for bug 1021023

Dan,

This is a half true bug, it only affects systems running with python2.4/2.5 and have python sqlite module built with sqlite version >= 3.6.19.

http://www.hwaci.com/sw/sqlite/foreignkeys.html

Python on debian, ubuntu and systems using python2.6 have sqlite3 with foreign keys.

squeeze ncode@atomsk:~$ ldd /usr/lib/python2.6/lib-dynload/_sqlite3.so
 linux-vdso.so.1 => (0x00007fff6f7f4000)
 libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0x00007fd33fc33000)
 libpthread.so.0 => /lib/libpthread.so.0 (0x00007fd33fa17000)
 libc.so.6 => /lib/libc.so.6 (0x00007fd33f6b4000)
 libdl.so.2 => /lib/libdl.so.2 (0x00007fd33f4b0000)
 /lib64/ld-linux-x86-64.so.2 (0x00007fd3400e3000)

squeeze ncode@atomsk:~$ dpkg -S /usr/lib/libsqlite3.so.0
libsqlite3-0: /usr/lib/libsqlite3.so.0

squeeze ncode@atomsk:~$ dpkg -l libsqlite3-0
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-=========================-=========================-==================================================================
ii libsqlite3-0 3.7.3-1 SQLite 3 shared library