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