Re: About sequences that works BAD !!!!

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: About sequences that works BAD !!!!
Date: 2006-06-14 18:39:33
Message-ID: 200606141439.33768.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wednesday 14 June 2006 02:02 pm, "Alexis Palma Espinosa" <apalma(at)uci(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Mark 2006-06-14 18:56:21 Requirement for PostgreSQL Database Developer
Previous Message Richard Huxton 2006-06-14 18:28:38 Re: About sequences that works BAD !!!!