ERROR: DefineQueryRewrite: rule plan string too big.

From: Haller Christoph <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: ERROR: DefineQueryRewrite: rule plan string too big.
Date: 2001-09-07 15:38:00
Message-ID: 200109071338.PAA12735@rodos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert J. Sanford, Jr. 2001-09-08 03:53:09 optimizing queries and indexes...
Previous Message Haller Christoph 2001-09-07 15:13:38 Re: