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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
