Horton

Re: Allowing DML RULEs that produce Read Only actions during RO xacts

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2009-12-06T15:58:29Z
Lists: pgsql-hackers 
Simon Riggs <simon@2ndQuadrant.com> writes:
> On Sun, 2009-12-06 at 10:26 -0500, Tom Lane wrote:
>> How would you "reroute" them without a non-read-only operation happening
>> somewhere along the line?

> I showed how in my example. The non-read-only operation happens on a
> remote server.

That seems awfully dubious from a transactional-safety point of view.

			regards, tom lane