Re: [sqlite] Question about foreign key

2012-10-20 Thread Igor Korot
Hi, Keith, On Sat, Oct 20, 2012 at 11:10 PM, Keith Medcalf wrote: > On Saturday, 20 October, 2012 at 23:42, Igor Korot wrote: > >> According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY >> support is disabled by default. > > Yes, foreign key enforcement is disabled by default. OK.

Re: [sqlite] Question about foreign key

2012-10-20 Thread Keith Medcalf
On Saturday, 20 October, 2012 at 23:42, Igor Korot wrote: > According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY > support is disabled by default. Yes, foreign key enforcement is disabled by default. > In order to enable it I need to compile SQLITE with 2 defines undefined. Not

Re: [sqlite] Question about foreign key

2012-10-20 Thread Pavel Ivanov
On Sat, Oct 20, 2012 at 10:41 PM, Igor Korot wrote: > Hi, ALL, > According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY > support is disabled by default. > In order to enable it I need to compile SQLITE with 2 defines undefined. Which also undefined by default. Any SQLITE_OMIT_* defi

[sqlite] Question about foreign key

2012-10-20 Thread Igor Korot
Hi, ALL, According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY support is disabled by default. In order to enable it I need to compile SQLITE with 2 defines undefined. I downloaded the file sqlite-amalgamation-3071400.zip, unpacked it, added .c and .h file to my project and inspected

Re: [sqlite] transaction commit is successful despite I/O error

2012-10-20 Thread Ryan Johnson
On 19/10/2012 4:40 PM, Efim Dyadkin wrote: Hi Richard, You are right about the purpose of unlink but it is out of context. There are a transaction in progress and hot journal on disk. If journal can't be deleted by the end of transaction, the transaction can't be considered to be successfull

Re: [sqlite] transaction commit is successful despite I/O error

2012-10-20 Thread Dan Kennedy
On 10/20/2012 09:14 PM, Simon Slavin wrote: On 19 Oct 2012, at 9:40pm, Efim Dyadkin wrote: You are right about the purpose of unlink but it is out of context. There are a transaction in progress and hot journal on disk. If journal can't be deleted by the end of transaction, the transaction can

Re: [sqlite] transaction commit is successful despite I/O error

2012-10-20 Thread Simon Slavin
On 19 Oct 2012, at 9:40pm, Efim Dyadkin wrote: > You are right about the purpose of unlink but it is out of context. There are > a transaction in progress and hot journal on disk. If journal can't be > deleted by the end of transaction, the transaction can't be considered to be > successfully

Re: [sqlite] transaction commit is successful despite I/O error

2012-10-20 Thread Efim Dyadkin
Hi Richard, You are right about the purpose of unlink but it is out of context. There are a transaction in progress and hot journal on disk. If journal can't be deleted by the end of transaction, the transaction can't be considered to be successfully finished. But current implementation of Sqli