Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Novice > Re: Sequences -...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 7 Topic 3074 of 3322
Post > Topic >>

Re: Sequences - jumped after power failure

by nobs@[EMAIL PROTECTED] (Emil Obermayr) Apr 15, 2008 at 12:50 PM

Maybe its because the sequence gets a batch of IDs in the cache and
discards it with a crash? So unused sequence-ID get lost, while the
sequence is reset to the number of the last really used ID during a
normal shutdown?

Just a thought.

-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
 




 7 Posts in Topic:
Sequences - jumped after power failure
steve@[EMAIL PROTECTED]   2008-04-15 09:21:05 
Re: Sequences - jumped after power failure
sdavis2@[EMAIL PROTECTED]  2008-04-15 05:47:33 
Re: Sequences - jumped after power failure
steve@[EMAIL PROTECTED]   2008-04-15 11:07:18 
Re: Sequences - jumped after power failure
nobs@[EMAIL PROTECTED] (  2008-04-15 12:50:49 
Re: Sequences - jumped after power failure
tgl@[EMAIL PROTECTED] (T  2008-04-15 10:58:17 
Re: Sequences - jumped after power failure
steve@[EMAIL PROTECTED]   2008-04-15 16:51:51 
Re: Sequences - jumped after power failure
steve@[EMAIL PROTECTED]   2008-04-15 18:04:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Dec 5 3:44:54 CST 2008.