Re: [GENERAL] Postrgres Sequence Error

2006-10-22 Thread Michael Fuhr
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

[GENERAL] Postrgres Sequence Error

2006-10-22 Thread carter ck
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 sol