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