From: Terry Lee Tucker <terry@esc1.com>
To: pgsql-sql@postgresql.org
Subject: Re: About sequences that works BAD !!!!
Date: Wed, 14 Jun 2006 14:39:33 -0400
Message-ID: <200606141439.33768.terry@esc1.com> (raw)
In-Reply-To: <251EA6C55832BE4C80F868CC951BA8CE02764F94@ucixw2.uci.cu>
References: <251EA6C55832BE4C80F868CC951BA8CE02764F94@ucixw2.uci.cu>
On Wednesday 14 June 2006 02:02 pm, "Alexis Palma Espinosa" <apalma@uci.cu>
thus communicated:
--> Hello everyone:
-->
-->
-->
--> 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...¿What we can do about it? -->
-->
-->
--> We hope you can help us.....
-->
-->
-->
This is doing exactly what it is supposed to do. See the docs:
http://www.postgresql.org/docs/7.4/static/functions-sequence.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: terry@esc1.com
Subject: Re: About sequences that works BAD !!!!
In-Reply-To: <200606141439.33768.terry@esc1.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox