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

Re: OT: Question about transactions

From: Paul Tomblin <ptomblin(at)gmail(dot)com>
To: Andrew Sullivan <ajs(at)commandprompt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: OT: Question about transactions
Date: 2008-08-12 21:24:08
Message-ID: 48A1FF78.6020002@gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Andrew Sullivan wrote:
> 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.

That seems like it might work.  Thanks.

-- 
Paul Tomblin <ptomblin(at)xcski(dot)com> http://blog.xcski.com/
Conspiracies abound:  If everyone's against you, the reason can't
_possibly_ be that you're a fuckhead.
               -- The Usenet Guide to Power Posting

In response to

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2008-08-12 23:37:01
Subject: Re: PreparedStatement timeouts?
Previous:From: Andrew SullivanDate: 2008-08-12 20:54:10
Subject: Re: OT: Question about transactions

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