Re: [GENERAL] DefineQueryRewrite: rule plan string too big--

From: mathprof(at)bigfoot(dot)com
To: Ed Loehr <eloehr(at)austin(dot)rr(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] DefineQueryRewrite: rule plan string too big--
Date: 2000-02-05 00:39:37
Message-ID: 200002050040.SAA01753@ogopogo.flash.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)austin(dot)rr(dot)com>
> To: mathprof(at)bigfoot(dot)com
> Cc: pgsql-general(at)postgreSQL(dot)org
> Subject: Re: [GENERAL] DefineQueryRewrite: rule plan string too big-- workaround?
>
> mathprof(at)bigfoot(dot)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
>
> ************
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message davidb 2000-02-05 00:48:33 Re: [GENERAL] using ID as a key
Previous Message kaiq 2000-02-04 23:39:06 Re: [GENERAL] using ID as a key