Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA33091 for ; Wed, 21 Jul 1999 05:44:48 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id 8D94F4B5A1; Wed, 21 Jul 1999 12:44:47 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAA77A; Wed, 21 Jul 1999 12:48:02 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <379594BB.1496E4FB@tech.com.au> References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 21 Jul 1999 12:45:16 +0300 To: Chris Bitmead From: Herouth Maoz Subject: Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Cc: "pgsql-sql@hub.org" At 12:36 +0300 on 21/07/1999, Chris Bitmead wrote: > I missed the original question, but don't you get sequential numbers as > long as cache is 0? No. If an insert failed or a transaction failed, the sequence remains in its new state. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma