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 6 of 7 Topic 3074 of 3191
Post > Topic >>

Re: Sequences - jumped after power failure

by steve@[EMAIL PROTECTED] (Steve T) Apr 15, 2008 at 04:51 PM

--=-KZk3BFoznpb172OBgTfi
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

Emil,
That would tend to make sense given the results I am seeing. I am/was
just paranoid that I've lost data - but everything says not an that its
just a blip in the sequencing.

On Tue, 2008-04-15 at 12:50 +0200, Emil Obermayr wrote:

> 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.



--=-KZk3BFoznpb172OBgTfi
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
  <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
  <META NAME="GENERATOR" CONTENT="GtkHTML/3.12.3">
</HEAD>
<BODY>
Emil,<BR>
That would tend to make sense given the results I am seeing. I am/was just
paranoid that I've lost data - but everything says not an that its just a
blip in the sequencing.<BR>
<BR>
On Tue, 2008-04-15 at 12:50 +0200, Emil Obermayr wrote:
<BLOCKQUOTE TYPE=CITE>
<PRE>
<FONT COLOR="#000000">Maybe its because the sequence gets a batch of IDs
in the cache and</FONT>
<FONT COLOR="#000000">discards it with a crash? So unused sequence-ID get
lost, while the</FONT>
<FONT COLOR="#000000">sequence is reset to the number of the last really
used ID during a</FONT>
<FONT COLOR="#000000">normal shutdown?</FONT>

<FONT COLOR="#000000">Just a thought.</FONT>
</PRE>
</BLOCKQUOTE>
<BR>
</BODY>
</HTML>

--=-KZk3BFoznpb172OBgTfi--
 




 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 Thu Aug 21 18:04:52 CDT 2008.