Re: changes sequences to unique

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Dave Stokes <dave(at)greatgeek(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: changes sequences to unique
Date: 2001-06-06 18:50:18
Message-ID: Pine.LNX.4.21.0106061449130.14315-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

How did you conclude that it doesn't provide unique numbers? A sequence gives unique values by definition (unless you allow it 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(at)greatgeek(dot)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(at)postgresql(dot)org)
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2001-06-06 18:57:38 Re: changes sequences to unique
Previous Message Stephan Szabo 2001-06-06 18:45:54 Re: changes sequences to unique