Re: [sqlite] Index for Primary Key column missing?

2008-02-21 Thread Neville Franks
Jens, Thanks for that. I incorrectly assumed because the index was named xxx_tags it wasn't for the 'tag' column, but related to the table, which is named 'tags'. I had read the content you referred to. Thursday, February 21, 2008, 11:11:19 PM, you wrote: JM> Am 21.02.2008 um 10:30 schrieb

Re: [sqlite] Index for Primary Key column missing?

2008-02-21 Thread Jens Miltner
Am 21.02.2008 um 10:30 schrieb Neville Franks: > I have created a table with a column: tag text primary key > > When I do: > sqlite> .indices tags > sqlite_autoindex_tags_1 > > I only see the one index which I assume is for the ROWID clm. No, this is the index for your 'tag' column as can be

[sqlite] Index for Primary Key column missing?

2008-02-21 Thread Neville Franks
I have created a table with a column: tag text primary key When I do: sqlite> .indices tags sqlite_autoindex_tags_1 I only see the one index which I assume is for the ROWID clm. I have inserted a row into the table, in case that is relevant. My understanding is that a primary key column will