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
