Tom Lane wrote:
> This is exactly what I'm talking about. The rtable for a query
> generated by a rule is the concatenation of the original query's rtable
> and the rule query's rtable. Therefore the RTE for table1 appears
> twice, once in the original INSERT query and once in the generated
> UPDATE query (even though the UPDATE query does not actually use that
> RTE in this case). This would be okay if the RTE's write permission
> flag were not context-dependent, but because it is, we have a problem.
OK, that makes more sense now. But why isn't table2 also in the rule
query's rtable?
Joe
