Re: [sqlite] Broken Foreign key

2018-11-13 Thread Thomas Kurz
Ok, now I understand. Thank you (and Richard) very much. - Original Message - From: Keith Medcalf To: SQLite mailing list Sent: Tuesday, November 13, 2018, 14:06:11 Subject: [sqlite] Broken Foreign key On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked: >May I ask why par

Re: [sqlite] Broken Foreign key

2018-11-13 Thread Keith Medcalf
On Tuesday, 13 November, 2018 05:47, Thomas Kurz asked: >May I ask why parent keys *must* have indexes? I don't see any >correlation between enforcing a client/parent-relationship and the >necessity for an index. I'm just asking to better understand. To me >it is clear that the parent column is

Re: [sqlite] Broken Foreign key

2018-11-13 Thread Richard Damon
anually index PRIMARY KEY columns as well or are those > auto-indexed? > > Kind reagrds, > Thomas > > > - Original Message - > From: Keith Medcalf > To: SQLite mailing list > Sent: Monday, November 12, 2018, 05:15:35 > Subject: [sqlite] Broken Foreign key

Re: [sqlite] Broken Foreign key

2018-11-13 Thread Thomas Kurz
hy does it need to have an index? And do I have to manually index PRIMARY KEY columns as well or are those auto-indexed? Kind reagrds, Thomas - Original Message - From: Keith Medcalf To: SQLite mailing list Sent: Monday, November 12, 2018, 05:15:35 Subject: [sqlite] Broken Foreign ke

Re: [sqlite] Broken Foreign key

2018-11-13 Thread Keith Medcalf
lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of J Decker >Sent: Tuesday, 13 November, 2018 04:33 >To: General Discussion of SQLite Database >Subject: Re: [sqlite] Broken

Re: [sqlite] Broken Foreign key

2018-11-13 Thread J Decker
.sqlite.org] On Behalf Of J Decker > >Sent: Sunday, 11 November, 2018 20:25 > >To: General Discussion of SQLite Database > >Subject: [sqlite] Broken Foreign key > > > >https://d3x0r.org:444/temporary/broken_fk.tgz (30k) > > > >this has a .option.db in i

Re: [sqlite] Broken Foreign key

2018-11-11 Thread Keith Medcalf
nly a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of J Decker >Sent: Sunday, 11 November, 2018 20:25 >To: General Discussion of SQLite Database >S

[sqlite] Broken Foreign key

2018-11-11 Thread J Decker
https://d3x0r.org:444/temporary/broken_fk.tgz (30k) this has a .option.db in it and a test.sh. It turns on foreign_keys, selects from the name_id that it says is a forieng key violation, and inserts into option4_map. option4_map has option_id(PK),parent_id(FK option_id),name_id(FK) option4_name