On 23/06/10 22:05, Robert Haas wrote:
On Wed, Jun 23, 2010 at 2:53 PM, Simon Riggs<[email protected]> 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
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
