Re: Non-primary key AutoField

2009-03-03 Thread NewSpire
> Django is optimized for the common case. Sure, it may well be that > it's easy to accommodate uncommon cases as well, and when it's > reasonable, we should definitely do so, but the reason it hasn't been > up to this point is simply that not enough people need it. I agree fully. I've only need

Re: Non-primary key AutoField

2009-03-01 Thread NewSpire
Now for some leg work. The simple part is to remove the primary key assert in AutoField.__init__. The hard part is that django creates tables with multiple sql statements. One for the table create and then one for each index. MySQL requires that auto_increment fields must be indexed. Since dja

Re: Non-primary key AutoField

2009-03-01 Thread NewSpire
> MySQL, if I recall correctly, > flat-out will not support this at all. Correct! MySQL definitely does not support multiple auto-increment fields. However, that is not what I'm talking about. I would just like the primary key requirement removed from the AutoField. MySQL definitely does not

Non-primary key AutoField

2009-02-28 Thread NewSpire
In ticket #8576 a request was made to remove the restriction that AutoFields must be primary keys so that multiple AutoFields could be used in a model. In MySQL multiple auto-increment fields does not make sense and probably does not make sense in any other database. However, I do think the case