Re: changes sequences to unique - Mailing list pgsql-admin

From Tom Lane
Subject Re: changes sequences to unique
Date
Msg-id 3546.991853858@sss.pgh.pa.us
Whole thread Raw
In response to changes sequences to unique  (Dave Stokes <dave@greatgeek.com>)
Responses Re: changes sequences to unique  (Stefan Huber <schweinsaug@crosswinds.net>)
List pgsql-admin
Dave Stokes <dave@greatgeek.com> writes:
> I have a sequence that I 'thought' was providing unique numbers but is
> not.  Is there someway to turn on unique-ness?

Huh?  nextval() should always produce unique values (unless the sequence
wraps around, of course).

            regards, tom lane

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: changes sequences to unique
Next
From: "Thalis A. Kalfigopoulos"
Date:
Subject: Re: changes sequences to unique