Bring it on! -- Sammy Spets Synerger Pty Ltd http://synerger.com On 30-May-07 02:43, Karoly Negyesi wrote:
Or maybe not.
Let me quote Moshe from http://lists.drupal.org/pipermail/development/2005-December/012108.html
"A long time ago, we made a big effort to be database independent and introducing our own sequences feature was part of that. We wanted to welcome all RDMS, even those without sequences."
Let's see
mysql -- native (auto_increment modifier) SQLite -- native (auto_increment modifier) postgresql -- native (serial type backed by sequences) Oracle -- doable (via sequences and a trigger) MSQQL -- native (identity type) DB2 -- doable (DEFAULT NEXT_VALUE OF sequence) Firebird -- doable (generator, trigger) MS Access -- native (autoincrement type)
Surely I have not covered all possible RDBMSes and the above might contain errors, I just spent ten minutes with googling this together.
But still. It seems that most RDBMSes that we considered supporting support these.
To continue quoting Moshe,
"I'd support a patch that removed drupal sequences in favor of built in auto-increment and such."
Let's hope he is not alone because http://drupal.org/node/49836#comment-251682 now contains such a patch.
Regards,
NK