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

From Thalis A. Kalfigopoulos
Subject Re: changes sequences to unique
Date
Msg-id Pine.LNX.4.21.0106061449130.14315-100000@aluminum.cs.pitt.edu
Whole thread Raw
In response to changes sequences to unique  (Dave Stokes <dave@greatgeek.com>)
List pgsql-admin
How did you conclude that it doesn't provide unique numbers? A sequence gives unique values by definition (unless you
allowit to cycle and you actually wrapped around the 2.1billion boundary) 

cheers,
thalis


On Wed, 6 Jun 2001, Dave Stokes wrote:

> I have a sequence that I 'thought' was providing unique numbers but is
> not.  Is there someway to turn on unique-ness?  Should I reload after
> adding unique to the sequence?  Any other thoughts on digging my way out
> of the problem?
>
> Thanks in advance!
> --
>
> Dave Stokes
> dave@greatgeek.com
> 817 329 9317
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: changes sequences to unique
Next
From: Stefan Huber
Date:
Subject: Re: changes sequences to unique