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