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