Re: [sqlite] Slow response using WHERE - IN

2014-07-27 Thread jose isaias cabrera
Clemens Ladisch wrote... On 07/26/2014 06:22 AM, jose isaias cabrera wrote: INSERT OR REPLACE INTO LSOpenProjects SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date != A.Date; What is A? Sorry, this should have been written like this. INSERT OR REPLACE INTO

Re: [sqlite] multi row inserts violate foreign key constraint

2014-07-27 Thread Clemens Ladisch
On 07/27/2014 12:11 PM, com...@gmx.ch wrote: > when enabling foreign_keys via > PRAGMA foreign_keys=ON; > multi row inserts fail when having a foreign key and adding a value as > well as the reference in a transaction fails as well. Normally, foreign key constraints are checked as soon as each

Re: [sqlite] multi row inserts violate foreign key constraint

2014-07-27 Thread Simon Slavin
On 27 Jul 2014, at 11:11am, com...@gmx.ch wrote: > Example is attached. We apologise, but it's intentionally difficult to attach files to posts to this list. If your text is short, could you just paste it into a post ? If it's long, can you put it on a server and post a pointer to it ?

[sqlite] unixGetPageSize needed but undefined

2014-07-27 Thread Alan Hourihane
Hi all, I logged this bug via Gentoo, but it should be done here... https://bugs.gentoo.org/show_bug.cgi?id=517110 " This function is wrapped up inside SQLITE_OMIT_WAL, whereas it's needed elsewhere. This function needs to be moved out of this ifdef. /* ** Return the system page size. ** **

[sqlite] multi row inserts violate foreign key constraint

2014-07-27 Thread com...@gmx.ch
Hi, when enabling foreign_keys via PRAGMA foreign_keys=ON; multi row inserts fail when having a foreign key and adding a value as well as the reference in a transaction fails as well. Example is attached. Fails for me on SQLite 3.8.2 2013-12-06 14:53:30

Re: [sqlite] AUTOINCREMENT

2014-07-27 Thread RSmith
On 2014/07/27 12:07, michael walsley wrote: Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value on insert is not null it doesn't get a new rowid, it just accepts the value as in the insert? Im trying to develop a win phone app in that data downloaded from the

Re: [sqlite] Slow response using WHERE - IN

2014-07-27 Thread Clemens Ladisch
On 07/26/2014 06:22 AM, jose isaias cabrera wrote: >INSERT OR REPLACE INTO LSOpenProjects > SELECT * FROM client.LSOpenProjects WHERE id = 1 AND Date != > A.Date; What is A? Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] AUTOINCREMENT

2014-07-27 Thread Clemens Ladisch
On 07/27/2014 12:07 PM, michael walsley wrote: > Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value > on insert is not null it doesn't get a new rowid, it just accepts the value > as in the insert? sqlite> create table t(x integer primary key autoincrement); sqlite>

[sqlite] AUTOINCREMENT

2014-07-27 Thread michael walsley
Why doesn't AUTOINCREMENT work like rowid, in that, with rowid if the value on insert is not null it doesn't get a new rowid, it just accepts the value as in the insert? Im trying to develop a win phone app in that data downloaded from the server needs to insert as it comes, but rows added on