Re: About sequences that works BAD !!!! - Mailing list pgsql-sql

From Terry Lee Tucker
Subject Re: About sequences that works BAD !!!!
Date
Msg-id 200606141439.33768.terry@esc1.com
Whole thread Raw
In response to About sequences that works BAD !!!!  ("Alexis Palma Espinosa" <apalma@uci.cu>)
List pgsql-sql
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: Whenwe insert in a table that has e unique
restrict,and this makes insertfails, 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


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: About sequences that works BAD !!!!
Next
From: "Mark"
Date:
Subject: Requirement for PostgreSQL Database Developer