Re: changes sequences to unique - Mailing list pgsql-admin

From Rene Pijlman
Subject Re: changes sequences to unique
Date
Msg-id 907tht4vrv0bp2eiqfp3a1hk46gco33pkr@4ax.com
Whole thread Raw
In response to Re: changes sequences to unique  (Stefan Huber <schweinsaug@crosswinds.net>)
List pgsql-admin
schweinsaug@crosswinds.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@spamcop.net>

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

pgsql-admin by date:

Previous
From: 高豪良\(Danny\)
Date:
Subject: Rserv install problem
Next
From: "Andy Jenks"
Date:
Subject: postmaster successfully started?