Re: [sqlite] Checkins 2694 and 2697 (order of columns in primary key)?

[D. Richard Hipp]

On Fri, 2005-09-16 at 07:34 -0400, Ned Batchelder wrote:
> I saw checkin 2694 ("The table_info pragma now gives the order of columns in
> the primary key"), and rejoiced.  I currently have to parse the sql from
> sqlite_master to dig up this information myself.Then came checkin 2697
> ("Undo check-in [2694]").  What happened?  
> 

That patch only works for tables with 255 or fewer
columns in the primary key.  Granted, that accounts for *most*
tables.  But I still do not like introducing arbitrary limits
like that.  And once I put something in a release, I'm
obliged to support it forever.  So I want to ponder the
issue a bit more first.
-- 
D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] Checkins 2694 and 2697 (order of columns in primary key)?

[Ned Batchelder]

I saw checkin 2694 ("The table_info pragma now gives the order of columns in
the primary key"), and rejoiced.  I currently have to parse the sql from
sqlite_master to dig up this information myself.Then came checkin 2697
("Undo check-in [2694]").  What happened?  

 

--Ned.

http://nedbatchelder.com