Rollback & Nextval fails

From: "Eriksson, Fredrik" <Fredrik_Eriksson(at)NAI(dot)com>
To: "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>
Subject: Rollback & Nextval fails
Date: 2000-05-29 08:54:14
Message-ID: 890BFCE1028AD211833700A0C9F2770C27E0B1@dns-155-111.dhcp.nai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Cheers,

Fredrik

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Gerhard Dieringer 2000-05-29 09:44:21 Antw: Rollback & Nextval fails
Previous Message Carolyn Wong 2000-05-29 05:37:47 date format