dbTalk Databases Forums  

[BUGS] BUG #2284: missing sequence number

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #2284: missing sequence number in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default [BUGS] BUG #2284: missing sequence number - 02-27-2006 , 11:16 AM







The following bug has been logged online:

Bug reference: 2284
Logged by:
Email address: suvarnat (AT) cygnus (DOT) stpp.soft.net
PostgreSQL version: 7.3.2
Operating system: linux
Description: missing sequence number
Details:

if the server shuts down abrupotly because of power failuar or any other
cause then the sequences tend to skip few numbers.
After restarting the postgresql server the nextval of sequence doest match
with the last number.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote
  #2  
Old   
Alvaro Herrera
 
Posts: n/a

Default Re: [BUGS] BUG #2284: missing sequence number - 02-27-2006 , 11:18 AM






suvarnat (AT) cygnus (DOT) stpp.soft.net wrote:

Quote:
if the server shuts down abrupotly because of power failuar or any other
cause then the sequences tend to skip few numbers.
After restarting the postgresql server the nextval of sequence doest match
with the last number.
This is per design, i.e. not a bug.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Reply With Quote
  #3  
Old   
Michael Fuhr
 
Posts: n/a

Default Re: [BUGS] BUG #2284: missing sequence number - 02-27-2006 , 11:23 AM



On Mon, Feb 27, 2006 at 11:52:19AM +0000, suvarnat (AT) cygnus (DOT) stpp.soft.net wrote:
Quote:
if the server shuts down abrupotly because of power failuar or any other
cause then the sequences tend to skip few numbers.
After restarting the postgresql server the nextval of sequence doest match
with the last number.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.4

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.