Postgres Pro
Downloads
Home   >   mailing lists

Re: Allowing DML RULEs that produce Read Only actions during RO xacts - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Allowing DML RULEs that produce Read Only actions during RO xacts
Date
Msg-id 24001.1260115109@sss.pgh.pa.us
Whole thread Raw
In response to Re: Allowing DML RULEs that produce Read Only actions during RO xacts  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Summary and Plan for Hot Standby
Next
From: Simon Riggs
Date:
Subject: Error message translation, with variable reason text