From: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: rules: evaluate inputs in advance |
Date: | 2006-05-12 14:22:00 |
Message-ID: | 1147443720.18683.31.camel@fotomarburg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, 2006-05-12 at 15:57 +0200, Martijn van Oosterhout wrote:
> It's a known problem. It's also one of the reasons why triggers are
> recommended over rules. And it's not desirable behaviour.
Well, triggers cannot be used to create writeable views, can they?
> There have been discussions about the problems
Do you have some pointers here? I did not find relevant discussions in
the archives (of gmane.org)
> Yet no-one has come up with an
> alternative that covers the current uses...
As far as I know, the rewriter simply copies plan tree nodes. I thought
about inserting an 'evaluate-only-once' node which is linked from all
rules and points to the expression to evaluate (instead of copying the
complete explession and evaluating it several times in the executor).
Regards
Markus
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-05-12 14:31:40 | Re: Connecting to PostgreSQL on Linux with windows |
Previous Message | Russ Brown | 2006-05-12 14:15:04 | Re: GUI Interface |