Received: from deimos.nc.com (deimos.nc.com [207.88.167.190]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA14290 for ; Wed, 4 Aug 1999 14:22:17 -0400 (EDT) (envelope-from astromonk@flashmail.com) Received: from flashmail.com (darwin.nc.com [172.17.17.51]) by deimos.nc.com (8.8.4/8.8.4) with ESMTP id LAA00584 for ; Wed, 4 Aug 1999 11:15:06 -0700 (PDT) Message-ID: <37A884F2.411E3D62@flashmail.com> Date: Wed, 04 Aug 1999 12:22:42 -0600 From: astromonk X-Mailer: Mozilla 4.6 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: sequences not reliable? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit rumor has it that if there is an abrupt power outage (not properly shut down) then when the system comes back up the sequence will roll by by 1. Is this true and has anyone seen it? How do you fix this so this does not happen or what is the best hack? will incrementing the sequence by 2 fix this? Is it rolled back by "1" or rolled back 1 "value" to the previous value? If it were rolled back by "1" then increment by 2 would fix things. thanks am (please CC: if you post)