Обсуждение: DefineQueryRewrite: rule plan string too big-- workaround?

I created what I thought was a fairly simple view, and got back:

ERROR:  DefineQueryRewrite: rule plan string too big.

Is there any workaround for this? I'm pretty sure the view is correct
otherwise-- if I edit it even slightly, the "CREATE" goes through fine and
the view works great (well, almost great-- not as well as if I didn't have
to edit the view to avoid the error!).

The limit for the rule plan string also seems awfully small-- my view
isn't more than a few lines long.

Thoughts or help?

mathprof@bigfoot.com wrote:
>
> I created what I thought was a fairly simple view, and got back:
>
> ERROR:  DefineQueryRewrite: rule plan string too big.
>
> The limit for the rule plan string also seems awfully small-- my view
> isn't more than a few lines long.
>
> Thoughts or help?

A very frequent problem, many reports in the list archive...Broken (or
shall I say unusable) since March, 1998, if I read the archives
correctly...IIRC, rumored to be fixed in v7.0 sometime in the coming
months...Until then, answer seems to be to make smaller views.
Bummer, yes.

Cheers,
Ed Loehr

Thanks... I found a sort of workaround that might help others. It's
possible to make views from other views, so I solved my problem by
creating an auxilary "viewname1" which did some of the work, and then
created a view "viewname" on "viewname1" which did the rest of the work.
Ugly and probably inefficient, but it seems to work!

On Fri, 4 Feb 2000, Ed Loehr wrote:

> Date: Fri, 04 Feb 2000 01:03:35 -0600
> From: Ed Loehr <eloehr@austin.rr.com>
> To: mathprof@bigfoot.com
> Cc: pgsql-general@postgreSQL.org
> Subject: Re: [GENERAL] DefineQueryRewrite: rule plan string too big-- workaround?
>
> mathprof@bigfoot.com wrote:
> >
> > I created what I thought was a fairly simple view, and got back:
> >
> > ERROR:  DefineQueryRewrite: rule plan string too big.
> >
> > The limit for the rule plan string also seems awfully small-- my view
> > isn't more than a few lines long.
> >
> > Thoughts or help?
>
> A very frequent problem, many reports in the list archive...Broken (or
> shall I say unusable) since March, 1998, if I read the archives
> correctly...IIRC, rumored to be fixed in v7.0 sometime in the coming
> months...Until then, answer seems to be to make smaller views.
> Bummer, yes.
>
> Cheers,
> Ed Loehr
>
> ************
>
>