Re: [sqlite] Foreign Key constraint problem while dropping tables inside transaction

2013-05-13 Thread Григорий Григоренко
Понедельник, 13 мая 2013, 17:03 +01:00 от Simon Davies : >On 13 May 2013 16:52, Simon Slavin < slav...@bigfraud.org > wrote: >> >> On 13 May 2013, at 3:54pm, Григорий Григоренко < grigore...@mail.ru > wrote: >> >>> sample database is: >>> >>> PRAGMA FOREIGN_KEYS=1;

Re: [sqlite] Foreign Key constraint problem while dropping tables inside transaction

2013-05-13 Thread Simon Davies
On 13 May 2013 16:52, Simon Slavin wrote: > > On 13 May 2013, at 3:54pm, Григорий Григоренко wrote: > >> sample database is: >> >> PRAGMA FOREIGN_KEYS=1; >> CREATE TABLE cat(id INTEGER PRIMARY KEY, name); >> INSERT INTO cat VALUES (1, 'Alice'); >> CREATE

Re: [sqlite] Foreign Key constraint problem while dropping tables inside transaction

2013-05-13 Thread Simon Slavin
On 13 May 2013, at 3:54pm, Григорий Григоренко wrote: > sample database is: > > PRAGMA FOREIGN_KEYS=1; > CREATE TABLE cat(id INTEGER PRIMARY KEY, name); > INSERT INTO cat VALUES (1, 'Alice'); > CREATE TABLE owner(pet INTEGER REFERENCES cat(id)); > INSERT INTO owner