From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
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:45:54 |
Message-ID: | Pine.BSF.4.21.0106061144270.16690-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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?
They should provide unique numbers. You could get non-unique values in
a column with a sequence default if you manually insert values (the
sequence wouldn't know about these). Can you give a sequence of events
from a blank start to replicate what you're seeing?
From | Date | Subject | |
---|---|---|---|
Next Message | Thalis A. Kalfigopoulos | 2001-06-06 18:50:18 | Re: changes sequences to unique |
Previous Message | Reinoud van Leeuwen | 2001-06-06 18:22:07 | Re: What CASE tools and clients for Postgres? |