X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3B0E09FA5C8 for ; Wed, 14 Jun 2006 15:40:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 53047-07 for ; Wed, 14 Jun 2006 15:40:19 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from rhino.esc1.com (dpc67142225134.direcpc.com [67.142.225.134]) by postgresql.org (Postfix) with ESMTP id CA2049FA3D7 for ; Wed, 14 Jun 2006 15:40:10 -0300 (ADT) Received: from rhino.esc1.com (localhost.localdomain [127.0.0.1]) by rhino.esc1.com (8.12.11/8.12.11) with ESMTP id k5EIdbEu016729 for ; Wed, 14 Jun 2006 14:39:39 -0400 Received: from localhost (localhost [[UNIX: localhost]]) by rhino.esc1.com (8.12.11/8.12.11/Submit) id k5EIdaHS016727 for pgsql-sql@postgresql.org; Wed, 14 Jun 2006 14:39:36 -0400 From: Terry Lee Tucker Organization: Enhanced Solutions Computing To: Subject: Re: About sequences that works BAD !!!! Date: Wed, 14 Jun 2006 14:39:33 -0400 User-Agent: KMail/1.5.3 References: <251EA6C55832BE4C80F868CC951BA8CE02764F94@ucixw2.uci.cu> In-Reply-To: <251EA6C55832BE4C80F868CC951BA8CE02764F94@ucixw2.uci.cu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200606141439.33768.terry@esc1.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/168 X-Sequence-Number: 25404 On Wednesday 14 June 2006 02:02 pm, "Alexis Palma Espinosa" = =20 thus communicated: =2D-> Hello everyone: =2D-> =2D-> =2D-> =2D-> We are working with serials fields and we found a problem with then: = When we insert in a table that has e unique restrict, and this makes insert fails, the sequence increments anyway...=BFWhat we can do about it? --> =2D-> =2D-> =2D-> We hope you can help us..... =2D-> =2D-> =2D-> This is doing exactly what it is supposed to do. See the docs: http://www.postgresql.org/docs/7.4/static/functions-sequence.html