Received: from eba-haus.de ([149.228.241.84]) by hub.org (8.9.3/8.9.3) with SMTP id FAA16910 for ; Mon, 29 May 2000 05:52:04 -0400 (EDT) (envelope-from DieringG@eba-haus.de) Received: from kopo001 by eba-haus.de;Mon, 29 May 2000 09:44:21 GMT with Novell_GroupWise; Mon, 29 May 2000 11:44:23 +0200 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Mon, 29 May 2000 11:44:21 +0200 From: "Gerhard Dieringer" To: , Subject: Antw: Rollback & Nextval fails Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id FAA16941 X-Archive-Number: 200005/180 Fredrik Eriksson wrote: > I have been trying the following SQL code : > BEGIN; > INSERT INTO table VALUES ( NEXTVAL('serial'), 'Data' ); > ROLLBACK; > And the insert function is rolled back but the serial sequence isn't. Hav I > misunderstood the functionality of rollback or is this a bug? Is there > someway to get the functionality that rollsback everything? It's not a bug but a feature. Sequence numbers exist to create unique entity-id-number with (usually) no external meaning, so 1.) there is no need to roll them back 2.) the system would have to keep a list, what sequence number were rolled back. Gerhard