>Huh? nextval() should always produce unique values (unless the sequence
>wraps around, of course).
What about explicitly overruling a sequence by INSERTing a specific value,
when it is not a primary key or defined as serial, but a manual sequence?
Stefan
--
I don't find it hard to meet exp
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 prov
Dave Stokes <[EMAIL PROTECTED]> 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, t
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 prov
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
[EMAIL PROTECTED]
817 329 93
