On Mon, Apr 19, 2004 at 20:16:15 -0300,
PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1139
> Logged by: Emil Tarazi
>
> Email address: [EMAIL PROTECTED]
>
> PostgreSQL version: 7.4
>
> Operating system: Linux
>
> Description: Auto-increment and Rollback
>
> Details:
>
> If a query is called within a BEGIN-COMMIT/ROLLBACK block that
> auto-increments some field, a ROLLBACK will not decrement that field.
Assuming you are refering to sequences, that's the way it is supposed
to work.
You really should only be using sequences to get unique values.
Within a single session expecting the values to be monotonically
increasing is also valid. Other than that you shouldn't be making
any assumptions about the relation between returned values.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
