[development] Why do we avoid auto-incrementing db columns?

[Ezra B. Gildesgame]

Barry,

I happened to discuss this with Greg Knaddison yesterday.
MySQL 4 does not support auto-incrementing columns. I believe  
Drupal.org uses MySQL 4, and one reason it has not been upgraded  
could be to avoid complications caused by changes in the way  
information, particularly international characters, are stored  
between 4 and and later versions.


Ezra Gildesgame

Developer
pingVision
1350 Pine Street, Suite 1
Boulder, CO 80302-4847
303.415.2559

On Apr 25, 2007, at 8:15 AM, Barry Jaspan wrote:

>
> Could someone either clue me in or point to a prior discussion about
> why Drupal avoids using auto-incrementing database columns?  If it is
> database compatibility, which versions of which databases that we
> support do not have it?
>
> Thanks,
>
> Barry
>