On 23/06/10 22:05, Robert Haas wrote:
> On Wed, Jun 23, 2010 at 2:53 PM, Simon Riggs<simon@2ndquadrant.com> wrote:
>> We could also allow SELECT ... FOR SHARE during Hot Standby, simply by
>> making it same as normal SELECT, without any ill effects.
>
> True.
Not really. It won't matter while the standby is in read-only mode, but
as soon as the server is promoted to master, you could have other
backends modifying rows that the still-running "SELECT ... FOR SHARED"
transaction should have locked.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com