Rollback & Nextval fails - Mailing list pgsql-sql

From Eriksson, Fredrik
Subject Rollback & Nextval fails
Date
Msg-id 890BFCE1028AD211833700A0C9F2770C27E0B1@dns-155-111.dhcp.nai.com
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: Carolyn Wong
Date:
Subject: date format
Next
From: "Gerhard Dieringer"
Date:
Subject: Antw: Rollback & Nextval fails