"G. Anthony Reina" <reina(at)nsi(dot)edu> writes:
> Now that I look at the CREATE SEQUENCE documentation, it appears to
> have a CYCLE flag which wraps the sequence around if it were to
> reach the MAXVALUE. Does anyone know if it wraps around to the next
> unused value? Or, if an index already exists at SERIAL value =
> MINVALUE, then will the INSERT get an error about duplicate
> insertions?
SERIAL columns get a unique index defined, so you'd get an error.
-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863