[GENERAL] Help with seq numbers...

[Cristian Prieto]

Hello, thanks a lot for your help and sorry for my newbie questions...   I have the following SP: It is indexed by iduser (a primary key)   CREATE FUNCTION store_users(name varchar, lastname varchar) RETURNS integer AS $body$ DECLARE     userid INTEGER := nextval('this_is_a_sequence'); BEGIN       BEGIN             INSERT INTO mytable (iduser, firstname, lname) VALUES (userid, name, lastname);       EXCEPTION             WHEN UNIQUE_VIOLATION THEN                 RETURN 0;       END;       RETURN userid; END; $body$ LANGUAGE plpgsql;   And it is working fine, but when I get a Unique_Violation (cuz there is a iduser already) the sequence still advance to the next value. There is any way to rollback or avoid holes in the sequence? I've read the manual and it says that nextval and currval could not be rolled back, that means that there is no way to avoid that trouble?   Sorry for my bad english and thanks again...