Postrgres Sequence Error - Mailing list pgsql-general

From carter ck
Subject Postrgres Sequence Error
Date
Msg-id BAY101-F34856F6A0327F76285D8D1D5000@phx.gbl
Whole thread Raw
Responses Re: Postrgres Sequence Error  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: unstable postgres on freebsd
Next
From: Michael Fuhr
Date:
Subject: Re: Postrgres Sequence Error