| From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
|---|---|
| To: | Neil Burrows <maillist(at)remo(dot)demon(dot)co(dot)uk> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] More Rule creation problems (and nowhere near 8K) |
| Date: | 2000-01-15 03:45:33 |
| Message-ID: | 387FED5D.50ACA580@austin.rr.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Neil Burrows wrote:
> Hi,
>
> I am having a problem trying to create a rule on a view and keep getting
>
> ERROR: DefineQueryRewrite: rule plan string too big.
>
> I've looked though the mailing list and docs and have seen mentions that
> the limit of a rule is 8192 characters. The rule (see below) is no more
> than 600 characters as it is and the error still appears even when all the
> whitespace is removed.
If I read the previous comments on this topic correctly, it's not the length
of your query that matters, but rather the length of what your query gets
translated into... a very annoying bug, indeed. This is the number one
barrier to my ODBC use as it makes views pretty much unusable.
Cheers,
Ed Loehr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerald Sievers | 2000-01-15 05:59:42 | Re: Postgresql Perl Problem |
| Previous Message | Blake Starkenburg | 2000-01-15 02:42:31 | Postgresql back-end - INTEGRATED - Excell Spreedsheets |