| 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: | Whole Thread | Raw Message | 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 |