Thread: Postrgres Sequence Error

Hi all,

Currently I am ancountering a sequnce error. THe sequence number is being
used up to 573, but, suddenly and unexpectedly, when I issue the select
nextval command, it gives the value of 400, which is currently occupied by a
record.

I am looking forward for any possible solution to solve this issue. Thank
you.

REgards,
Chun Kai

_________________________________________________________________
Get an advanced look at the new version of MSN Messenger.
http://messenger.msn.com.sg/Beta/Default.aspx

On Mon, Oct 23, 2006 at 08:27:46AM +0800, carter ck wrote:
> Currently I am ancountering a sequnce error. THe sequence number is being
> used up to 573, but, suddenly and unexpectedly, when I issue the select
> nextval command, it gives the value of 400, which is currently occupied by
> a record.

What do you mean by "the sequence number is being used up to 573"?
Are you saying that nextval() returns 573 and then returns 400?  Or
do you mean that a table's serial column has values up to 573?  In
the latter case somebody might have inserted values not obtained
from the sequence and now the sequence is colliding with those
values.

Is it possible that something is resetting the sequence?  Have you
enabled statement logging to investigate?

--
Michael Fuhr