Received: from hercules.telenet-ops.be (hercules.telenet-ops.be [195.130.132.33]) by hub.org (8.9.3/8.9.3) with SMTP id NAA34942 for ; Tue, 20 Jul 1999 13:15:22 -0400 (EDT) (envelope-from frederic.de.leersnijder@pandora.be) Received: (qmail 13573 invoked from network); 20 Jul 1999 17:15:19 -0000 Received: from unknown (HELO pandora.be) ([195.130.148.212]) (envelope-sender ) by hercules.telenet-ops.be (qmail-ldap-1.03) with SMTP for ; 20 Jul 1999 17:15:19 -0000 Sender: frederic Message-ID: <3794A9B3.C323DC4A@pandora.be> Date: Tue, 20 Jul 1999 18:54:11 +0200 From: Frederic De Leersnijder X-Mailer: Mozilla 4.51 [en] (X11; I; Linux 2.2.5-15 i586) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: Can I prevent my sequence to increment if an insert is rejected? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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