Re: [sqlite] constraint failed message and no clue what went wrong

2016-05-29 Thread Dominique Devienne
On Monday, May 23, 2016, Bernd Lehmkuhl wrote: > > > Dominique Devienne > hat am 23. Mai > 2016 um 13:42 > Could it be your you "knoten" and "punkte" tables have values with the > same IDs? > > Gotcha! Thanks. Even though I claimed

[sqlite] constraint failed message and no clue what went wrong

2016-05-23 Thread Bernd Lehmkuhl
> Dominique Devienne hat am 23. Mai 2016 um 13:42 > geschrieben: > > > On Mon, May 23, 2016 at 12:22 PM, Bernd Lehmkuhl mailbox.org > > wrote: > > > > > Dominique Devienne hat am 23. Mai 2016 um 11:20 > > geschrieben: > > > On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl < > >

[sqlite] constraint failed message and no clue what went wrong

2016-05-23 Thread Dominique Devienne
On Mon, May 23, 2016 at 12:22 PM, Bernd Lehmkuhl wrote: > > > Dominique Devienne hat am 23. Mai 2016 um 11:20 > geschrieben: > > On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl < > bernd.lehmkuhl at mailbox.org > > > [...] What might cause a "constraint failed" message following > this command:

[sqlite] constraint failed message and no clue what went wrong

2016-05-23 Thread Bernd Lehmkuhl
> Dominique Devienne hat am 23. Mai 2016 um 11:20 > geschrieben: > > > On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl mailbox.org > > wrote: > > > [...] What might cause a "constraint failed" message following this > > command: [...] > > > > Which version of SQLite? More recent ones tell

[sqlite] constraint failed message and no clue what went wrong

2016-05-23 Thread Dominique Devienne
On Mon, May 23, 2016 at 10:39 AM, Bernd Lehmkuhl wrote: > [...] What might cause a "constraint failed" message following this > command: [...] > Which version of SQLite? More recent ones tell you which constraint failed, when they are named, which yours are (a good thing IMHO). So using a

[sqlite] constraint failed message and no clue what went wrong

2016-05-23 Thread Bernd Lehmkuhl
Dear list, having the following database schema: /*** t_geometrie_typ ***/ CREATE TABLE t_geometrie_typ( auto_id INTEGER PRIMARY KEY AUTOINCREMENT, -- automatically generated id as link to the r*Tree index id TEXT UNIQUE NOT NULL, typ TEXT COLLATE NOCASE NOT NULL, objektart TEXT NOT