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

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?
Date: 2000-02-04 07:03:35
Message-ID: 389A79C7.BABB4DA@austin.rr.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yury Don 2000-02-04 10:32:20 pl/pgsql and national characters
Previous Message mathprof 2000-02-04 05:50:59 DefineQueryRewrite: rule plan string too big-- workaround?