Postrgres Sequence Error

From: "carter ck" <carterck32(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postrgres Sequence Error
Date: 2006-10-23 00:27:46
Message-ID: BAY101-F34856F6A0327F76285D8D1D5000@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-10-23 02:16:14 Re: Postrgres Sequence Error
Previous Message brian 2006-10-22 23:01:02 Re: Column Deletion