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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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