Re: A problem in inheritance

[Jim Nasby <decibel(at)decibel(dot)org>]

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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)