On Jun 20, 2007, at 12:53 PM, Talha Khan wrote:
THE ACTUAL TEST:
DROP RULE account_login_no_update ON account_login;
UPDATE account_login set originating_source = 'xxx';
Now the update should not effect the child table but it does,
evident
from the output of the following query:
That's because you dropped the rule that would have affected that
query. Remember that rules effectively work on the query strings
themselves, so to impact that update you'd have to have a rule on
account_login. No rule on a child table will matter.
--
Jim Nasby jim@xxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
