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
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