sequences in transaction blocks

From: "Marian Naghen" <naghen(at)ratb(dot)ro>
To: <pgsql-general(at)postgresql(dot)org>
Subject: sequences in transaction blocks
Date: 2005-12-19 09:39:11
Message-ID: 003401c60480$114271d0$f503a8c0@lapcontr01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to insert records inside a transaction block (BEGIN - COMMIT/ROLLBACK). If the transaction fails,
the sequence do not rollback and retain the new value.

This is the default behavior of sequences ?

I use the following table:

CREATE TABLE proceduri
(
procedura_id int4 NOT NULL DEFAULT nextval('proceduri_proceduri_id_seq'::regclass),
tip_procedura_id int4,
....
CONSTRAINT proceduri_pkey PRIMARY KEY (procedura_id)
)
WITH OIDS;

where 'proceduri_proceduri_id_seq is:

CREATE SEQUENCE proceduri_proceduri_id_seq
INCREMENT 1
MINVALUE 1000000000
MAXVALUE 1099999999
START 1000000001
CACHE 1;

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marian Naghen 2005-12-19 09:57:26 Re: sequences in transaction blocks
Previous Message Guido Neitzer 2005-12-19 09:26:55 Re: sequences w/o holes