Thread: Re: default_transaction_isolation = serializable causes crash under Hot Standby

Simon Riggs  wrote:
> The only way default_transaction_isolation = serializable would be
> acceptable when hot_standby = on is if we silently downgrade the
> isolation level to read committed. That way everything just works,
> albeit not quite as requested. So I think that's the best way
> forwards.
I guess I don't see much alternative.  Did you want to code that (I
seem to remember you saying that in an earlier post) or would you
like me to do it?
-Kevin

On Sun, Apr 29, 2012 at 5:54 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
> Simon Riggs  wrote:
>
>> The only way default_transaction_isolation = serializable would be
>> acceptable when hot_standby = on is if we silently downgrade the
>> isolation level to read committed. That way everything just works,
>> albeit not quite as requested. So I think that's the best way
>> forwards.
>
> I guess I don't see much alternative.  Did you want to code that (I
> seem to remember you saying that in an earlier post) or would you
> like me to do it?

I'll happily do that, unless you wish to.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services