Re: MySQL 4.1 Features

From: Neil Conway <neilc(at)samurai(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MySQL 4.1 Features
Date: 2002-12-18 23:24:20
Message-ID: 1040253860.356.67.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, 2002-12-18 at 01:49, Christopher Kings-Lynne wrote:
> Looks like they've caught up on a lot of our features. I have to say I
> appreciate them adding SERIAL as an alias for AUTO_INCREMENT. Perhaps we
> should return the favour? :)

Well, it's not the same as PostgreSQL's serial (which is a 32-bit NOT
NULL incrementing integer -- MySQL's serial is a 64-bit unique, NOT NULL
incrementing integer).

Personally, I think the implementations are different enough that making
AUTO_INCREMENT an alias for SERIAL on the PostgreSQL side of things
would just confuse the situation further...

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2002-12-18 23:39:05 Re: 7.3.1 stamped
Previous Message Bruce Momjian 2002-12-18 21:28:13 Re: 7.3.1 stamped