Re: Problems with transactions and sequences

On 28 Aug 2003 at 14:35, Sune Nielsen wrote:
> INSERT INTO Users (name) VALUES ('JohnDoe');
> SELECT CURRVAL('users_bid_seq');
>
> This works perfectly(!), but my project involves multiple simultanous
> users so I have to use transactions like this:
>
> BEGIN;
> INSERT INTO Users (name) VALUES ('JohnDoe');
> SELECT CURRVAL('users_bid_seq');
> COMMIT;

You need to extract the current val first and explicitly use it in insert
statement. That way you won't have to produce work-arounds later..

Bye
Shridhar

--
Vulcans do not approve of violence. -- Spock, "Journey to Babel", stardate
3842.4