On Mon, Feb 14, 2005 at 15:12:56 -0600,
Cristian Prieto <[EMAIL PROTECTED]> wrote:
>
> 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?
Why do you want to do this? If you really must have consecutive values, you
need to take a different approach. If you just need unique values, then
don't worry about gaps.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
