| 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: | Whole Thread | Raw Message | 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? |