Re: The rule question before, request official documentation on the problem

> Rules mess with queries. For data copying/archiving kinds of tasks,
> triggers are a better bet, like you suggested in your original post.
>
>> Let me put that a different way:  rules can *only* be used where data
>> integrity is not at stake.  My own thinking is that it might be time to
>> make an official recommendation that they are only safe for views.
>
> NEW and OLD mean different things in a PL/pgSQL context and a Rules
> context.
> In PL/pgSQL NEW and OLD are values, in Rules (which specifically mess
> with
> queries) they are expressions.
>
> The fact that the same words mean different things in different contexts
> is a bit unfortunate but not as messy as say using "NEWEXPR" in the
> Rules context would be.


    Since we now have UPDATE/INSERT/DELETE RETURNING, one could imagine the
rules using these to access the actual rows and not the expressions...

    But there is a perfectly valid argument against that :

    - There already is a mechanism designed specifically for this purpose
(triggers).
    - It works perfectly.
    - Rules are supposed to rewrite queries to do stuff like views.

    It should be mentioned in the docs, though : someone with an account on
the PG site should copypaste this mail exchange in the comments field...