Ummm...this is not a bug - it is utterly essential that sequences are not
rolled back!!!
Think about this:
Sequence counter is 9
Transaction 1 gets sequence no. 10
Transaction 2 gets sequence no. 11
transaction 1 rolls back, sequence no. reset to 9
Transaction 3 gets sequence number 10
Transaction 4 gets sequence number 11 - BAM!!!
Chris
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Bhuvan A
> Sent: Tuesday, 12 February 2002 1:26 PM
> To: pgsql-sql@postgresql.org
> Subject: [SQL] Sequencing Problem in Transaction..
>
>
>
> Dear All,
>
> In postgresql 7.1, there is a problem in sequence.
>
> While rollbacking in transaction mode, the sequences are not actually
> getting rolled back. This problem is still there in 7.2, it seems!
>
> When they planned to fix this? Any idea?
>
> With Regards,
> Bhuvaneswaran.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>