Re: [sqlite] Android SQLite 3.8.2 issue with triggers & constraints

2014-01-02 Thread Douglas Orr
Thanks, Dan, that does the trick. I didn't know that sqlite used any temporary files that weren't based on the database filename, but that makes perfect sense. Cheers, Doug On Wed, Jan 1, 2014 at 1:52 PM, Dan Kennedy wrote: > On 12/31/2013 10:03 PM, Douglas Orr wrote: > >> Hi, >> >> I have run

Re: [sqlite] Android SQLite 3.8.2 issue with triggers & constraints

2014-01-01 Thread Dan Kennedy
On 12/31/2013 10:03 PM, Douglas Orr wrote: Hi, I have run into an issue when trying to use triggers with column constraints on Android (using our build of SQLite 3.8.2, not Android's built-in version from native code.) Executing the following on a file-backed database fails: CREATE TABLE thin

[sqlite] Android SQLite 3.8.2 issue with triggers & constraints

2014-01-01 Thread Douglas Orr
Hi, I have run into an issue when trying to use triggers with column constraints on Android (using our build of SQLite 3.8.2, not Android's built-in version from native code.) Executing the following on a file-backed database fails: CREATE TABLE things (number INTEGER NOT NULL); CREATE TRIGGER