Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big.

2001-09-07 Thread Tom Lane
Haller Christoph <[EMAIL PROTECTED]> writes: > 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). Indeed. > Is this fixed

[SQL] ERROR: DefineQueryRewrite: rule plan string too big.

2001-09-07 Thread Haller Christoph
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