On 10/03/2015 02:04 AM, Clemens Ladisch wrote:
> Hi,
>
> the R-tree documentation says:
> | Attempts to insert something other than an integer into the first
> | column, or something other than a numeric value into the other
> | columns, will result in an error.
>
> This is not actually true:
>
>>
On 10/03/2015 03:19 AM, Andrew Cunningham wrote:
>
>
> SQLite uses a counter to enforce deferred foreign keys. Each time an
> operation violates a constraint it increments that counter.
>
> If the counter is greater than 0, then for every operation that might
> potentially correct t
On 3 Oct 2015, at 12:19am, Jim Morris wrote:
> I'm using an archaic version, I know, but busy_timeout doesn't seem to work.
> It doesn't return the value I set. When was it added?
>
> sqlite3 temp.db
> SQLite version 3.5.9
> Enter ".help" for instructions
> sqlite> PRAGMA busy_timeout=3;
On 2015-10-03 01:51 PM, Dan Kennedy wrote:
>
> Ok. My first guess is that you are missing the "suggested index" on
> the child table. Without this, if there is a foreign key violation in
> the db, each insert on the parent table will cause a linear scan of
> the entire child table. With the in
On 10/2/15, Jim Morris wrote:
> I'm using an archaic version, I know, but busy_timeout doesn't seem to
> work. It doesn't return the value I set. When was it added?
2012-12-12 (3.7.15)
>
> sqlite3 temp.db
> SQLite version 3.5.9
> Enter ".help" for instructions
> sqlite> PRAGMA busy_timeout=300
5 matches
Mail list logo