Re: Changing ids conflicting with serial values?

From: Marc Boucher <achernar(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing ids conflicting with serial values?
Date: 2005-11-03 18:46:13
Message-ID: rmmkm19gebtdiafu7207n8bh14oul03mov@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 02 Nov 2005 19:29:10 -0800, you wrote:

>It's a migration thing - MySQL prevented this
>situation due to the way it handles auto_increment (it will never assign
>you an id that already exists).

AFAIK, in mysql, if you modify a serial by setting it to the max value for
this type, mysql will fail all new inserts.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard_D_Levine 2005-11-03 20:03:02 Re: OT It is here: Oracle 10g Express
Previous Message Wes Williams 2005-11-03 18:08:01 Re: OT It is here: Oracle 10g Express