Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Postrgres Sequence Error


  • From: "carter ck" <carterck32(at)hotmail(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Postrgres Sequence Error
  • Date: Mon, 23 Oct 2006 08:27:46 +0800
  • Message-id: <BAY101-F34856F6A0327F76285D8D1D5000(at)phx(dot)gbl>

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




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group