From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Bhuvan A <bhuvansql@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Sequencing Problem in Transaction..
Date: Mon, 11 Feb 2002 22:21:42 -0800 (PST)
Message-ID: <20020211221922.S88298-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <Pine.LNX.4.20.0202121051220.16908-100000@Larry.bks>
On Tue, 12 Feb 2002, Bhuvan A wrote:
>
> 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!
>
Probably never, this is the intented behavior. If rollbacks rolled the
sequences back then you'd have to wait for the first transaction to
rollback or commit before giving the number out to a second transaction
running at the same time (thus you'd effectively be limited to a single
concurrent inserting transaction for most uses of sequences)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, bhuvansql@yahoo.com
Subject: Re: Sequencing Problem in Transaction..
In-Reply-To: <20020211221922.S88298-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox