Re: OT: Question about transactions - Mailing list pgsql-jdbc

From Andrew Sullivan
Subject Re: OT: Question about transactions
Date
Msg-id 20080812205410.GE27744@commandprompt.com
Whole thread Raw
In response to OT: Question about transactions  ("Paul Tomblin" <ptomblin@gmail.com>)
Responses Re: OT: Question about transactions  (Paul Tomblin <ptomblin@gmail.com>)
List 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@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

pgsql-jdbc by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: OT: Question about transactions
Next
From: Paul Tomblin
Date:
Subject: Re: OT: Question about transactions