Postgres Pro
Downloads
Home   >   mailing lists

Can I prevent my sequence to increment if an insert is rejected? - Mailing list pgsql-sql

From Frederic De Leersnijder
Subject Can I prevent my sequence to increment if an insert is rejected?
Date
Msg-id 3794A9B3.C323DC4A@pandora.be
Whole thread Raw
Responses Re: [SQL] Can I prevent my sequence to increment if an insert is rejected?  ("tjk@tksoft.com" <tk@uno.tksoft.com>)
Re: [SQL] Can I prevent my sequence to increment if an insert is rejected?  (Herouth Maoz <herouth@oumail.openu.ac.il>)
List pgsql-sql
Tree view 
Hi,

when I try to insert a record and it curses with fields with a unique
key on them my sequence I use for my primary key does increment. How can
I prevent this from happening?


Thanks
Frederic

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] bad select performance for where (x=1 or x=3)
Next
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] Can I prevent my sequence to increment if an insert is rejected?