Re: changes sequences to unique

From: Rene Pijlman <reageer(dot)in(dot)de(dot)nieuwsgroep(at)onzin-adres(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: changes sequences to unique
Date: 2001-06-06 21:10:48
Message-ID: 907tht4vrv0bp2eiqfp3a1hk46gco33pkr@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

schweinsaug(at)crosswinds(dot)net (Stefan Huber) schreef:
>>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?

Then the sequence will still produce unique values. Its just the
database column that contains a duplicate :-)

--
Vriendelijke groet,
René Pijlman <rpijlman(at)spamcop(dot)net>

Wat wil jij leren?
http://www.leren.nl/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2001-06-07 01:48:45 Re: Intentionally splitting data in a table across files. (fwd)
Previous Message Stefan Huber 2001-06-06 20:09:14 Re: changes sequences to unique