Received: from th00.opsion.fr (th00.opsion.fr [195.219.20.10]) by postgresql.org (Postfix) with SMTP id CBE8D475898 for ; Fri, 12 Apr 2002 21:17:00 -0400 (EDT) Received: from 10.1.1.17 [10.1.1.17] by th00.opsion.fr id 200204130116.2bed; Sat, 13 Apr 2002 01:16:43 GMT Send-By: 202.181.138.12 with Mozilla/4.78 [en] (Win95; U) To: Subject: Re: Problem With A Rule (clear version) From: X-Priority: 3 (normal) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Date: Sat, 13 Apr 2002 01:16:43 GMT Message-id: <200204130116.2bed@th00.opsion.fr> X-Archive-Number: 200204/165 X-Sequence-Number: 7429 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