| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Questions about SERIAL type |
| Date: | 2001-11-28 23:38:54 |
| Message-ID: | m3n116mpo1.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | G. Anthony Reina | 2001-11-28 23:42:47 | Re: Questions about SERIAL type |
| Previous Message | Ned Wolpert | 2001-11-28 23:37:50 | Re: Questions about SERIAL type |