[Open-bio-l] Re: [Bioperl-l] biosql primary key generation

[Todd Richmond]

On 8/10/02 10:23 PM, "Hilmar Lapp" <hlapp@gnf.org> wrote:

> The problem with the topic is that the MySQL idiosyncratic way of
> generating PKs behind the scenes via AUTO_INCREMENT fields is
> completely incompatible with any other reasonable RDBMS, including
> Postgres and Oracle.

Is the problem that Oracle and Postgres don't have AUTO_INCREMENT or that
MySQL doesn't support sequences? Because you can duplicate AUTO_INCREMENT in
Oracle using a sequence and an insert trigger, so that it's no different
than MySQL. 

Tpdd

-- 
Todd Richmond, PhD
http://cellwall.stanford.edu/todd
email: todd@verdant.stanford.edu