Thank you again! Tom,
You have reminded me to narrow down the problem. I
tested it in a brand new simplified database where
only related tables and rule are created. The rule I
had problem works fine, and fast, in this simplified
database.
I wonder my working database is corrupted by some
orphan pg_class records, constraints, triggers, etc.
So, please ignore this rule problem as it is actually
ok.
Regards,
cn
--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com