On Sun, 2009-12-06 at 10:26 -0500, Tom Lane wrote: > Simon Riggs <si...@2ndquadrant.com> writes: > > I would like to allow RULEs ON INSERT, ON UPDATE and ON DELETE during > > read only transactions iff they generate only SELECT statements that act > > INSTEAD OF the actual event. > > I don't actually believe there is any use case for such a thing. > > > This would be a small, but useful additional feature for Hot Standby, > > since it would allow INSERT, UPDATE, DELETE statements to be re-routed, > > for various applications. > > 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. If there are additional technical reasons why not, that's fine. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers