Re: Sequencing Problem in Transaction..

On Feb 12, Christopher Kings-Lynne wrote:

> 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!!!
>
Good and Thankx!!!

Regards,
Bhuvaneswar.

> Chris
>
> > -----Original Message-----
> > From: pgsql-sql-owner(at)postgresql(dot)org
> > [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Bhuvan A
> > Sent: Tuesday, 12 February 2002 1:26 PM
> > To: pgsql-sql(at)postgresql(dot)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(at)postgresql(dot)org)
> >
>