Postgres Pro
Downloads
Home   >   mailing lists

Re: Changing ids conflicting with serial values? - Mailing list pgsql-general

From Marc Boucher
Subject Re: Changing ids conflicting with serial values?
Date
Msg-id rmmkm19gebtdiafu7207n8bh14oul03mov@4ax.com
Whole thread Raw
In response to Re: Changing ids conflicting with serial values?  (Steven Brown <swbrown@ucsd.edu>)
Responses Re: Changing ids conflicting with serial values?  (Alex Turner <armtuk@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: rh7.3 binaries
Next
From: Omachonu Ogali
Date:
Subject: Array Values and References