Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f87Dc4787930 for ; Fri, 7 Sep 2001 09:38:04 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id PAA15087 for ; Fri, 7 Sep 2001 15:38:00 +0200 (METDST) From: Haller Christoph Message-Id: <200109071338.PAA12735@rodos> Subject: ERROR: DefineQueryRewrite: rule plan string too big. To: pgsql-sql@postgresql.org Date: Fri, 07 Sep 2001 15:38:00 METDST X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200109/26 X-Sequence-Number: 4672 I tried to create a view as follows create view sesql_userindexes as SELECT c.relname AS TBL_NAME, i.relname AS IDX_NAME, x.indisunique AS UNIQUE_FLAG, 1+ (CASE WHEN x.indkey[1]=0 THEN 0 ELSE 1 END)+(CASE WHEN x.indkey[2]=0 THEN 0 ELSE 1 END)+ (CASE WHEN x.indkey[3]=0 THEN 0 ELSE 1 END)+(CASE WHEN x.indkey[4]=0 THEN 0 ELSE 1 END)+ (CASE WHEN x.indkey[5]=0 THEN 0 ELSE 1 END)+(CASE WHEN x.indkey[6]=0 THEN 0 ELSE 1 END)+ (CASE WHEN x.indkey[7]=0 THEN 0 ELSE 1 END) AS IDXCOL_TOTAL, x.indkey AS COL_SEQ FROM pg_index x, pg_class c, pg_class i WHERE ((c.oid = x.indrelid) AND (i.oid = x.indexrelid)) and not (c.relname ~* 'pg_') ; I received the error message ERROR: DefineQueryRewrite: rule plan string too big. If do the SELECT without creating the view, it works as intended. I have to mention I am still working on version 6.1 (shame on me). Is this fixed in the upgrade versions? Or does anybody have an idea to word it smaller? Thanks in advance, Christoph