Re: [GENERAL] Strange permission problem regarding pg_settings

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