Re: SSI, simplified - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: SSI, simplified
Date
Msg-id 87aainhk1b.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: SSI, simplified  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: SSI, simplified  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> Not sure how to handle that. My understanding is that we are replacing
> the old Serializable mode with the new Serializable mode. The old way
> works, but the new way doesn't. I don't think we should throw an error;
> we just need to document that it works the old way on HS and the new way
> everywhere else. Maybe that's inconsistent, but throwing errors isn't
> useful in places where there didn't used to be any.

Well if you want the old behaviour you can ask for REPEATABLE READ and
have it.  Granted, that means you have to edit the application code that
talks to the Hot Standby, but surely you want to edit the same code when
it talks to the master to ask the proper level of serialisation, which
just changed underneath you?

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Patch to add a primary key using an existing index
Next
From: Simon Riggs
Date:
Subject: Re: SSI, simplified