Re: [sqlite] Primary Key

Robert Simpson wrote: -Original Message- From: andy [mailto:[EMAIL PROTECTED] Sent: Sunday, February 12, 2006 6:38 PM To: sqlite-users@sqlite.org Subject: [sqlite] Primary Key I'm using sqlite 3.2.8 I have a table: create table lookups ( id integer, descr varchar(80),

RE: [sqlite] unaligned access with sqlite 3.3.3 on IA64

Thanks for the fix, every thing seems to work fine with sqlite-3.3.4 Regards Chandan Dutta Chowdhury -Original Message- From: Chowdhury, Chandan Dutta Sent: Saturday, February 11, 2006 12:32 PM To: [EMAIL PROTECTED]; sqlite-users@sqlite.org Subject: RE: [sqlite] unaligned access with

RE: [sqlite] Primary Key

> -Original Message- > From: andy [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 12, 2006 6:38 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Primary Key > > I'm using sqlite 3.2.8 > > I have a table: > > create table lookups > ( >id integer, >descr varchar(80), >

[sqlite] Primary Key

I'm using sqlite 3.2.8 I have a table: create table lookups ( id integer, descr varchar(80), codetype integer, primary key(id) ); when I use: pragma index_list(lookups); It returns nothing. However, if I change the id field to text instead of integer, then it shows: