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;