Skip site navigation (1) Skip section navigation (2)

Re: OT: Question about transactions

From: Andrew Sullivan <ajs(at)commandprompt(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: OT: Question about transactions
Date: 2008-08-12 20:54:10
Message-ID: 20080812205410.GE27744@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Tue, Aug 12, 2008 at 04:09:48PM -0400, Paul Tomblin wrote:
> they go to process the second message?  Could they do a "BEGIN
> TRANSACTION" at the start and "END TRANSACTION" when they're done
> processing, even though the processing only does queries and not
> updates? 

Try SERIALIZABLE mode.  If I understand you correctly, it will do what
you need.

A

-- 
Andrew Sullivan
ajs(at)commandprompt(dot)com
+1 503 667 4564 x104
http://www.commandprompt.com/

In response to

Responses

pgsql-jdbc by date

Next:From: Paul TomblinDate: 2008-08-12 21:24:08
Subject: Re: OT: Question about transactions
Previous:From: Richard BroersmaDate: 2008-08-12 20:21:53
Subject: Re: OT: Question about transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group