Thread: rule plan string too big.

Umm, I am creating a big view and then I get:

PostgresSQL error message: ERROR:
DefineQueryRewrite: rule plan string too big.

This is on 6.4.2

Any hints?

Dirk

>
>
> Umm, I am creating a big view and then I get:
>
> PostgresSQL error message: ERROR:
> DefineQueryRewrite: rule plan string too big.
>
> This is on 6.4.2
>
> Any hints?

    It's a known problem - not solved yet.

    Currently  the  only  possible  solution  is  to increase the
    blocksize (defaults to 8K). Don't forget to run initdb after!


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #

Hi!
I'm wonder if there is available such a type like byte
I mean integers, which are < 256
I don't find such a type in docs, so I think, I should rather create it by
myself.
Unfortunately I'm new with this stuff, so I need help -
I found construction of needed sql statement, but explanations in docs are
for me too short ;-)
so -
    create type byte(
            INTERNALLENGTH=1,
            INPUT = my_proc_1,
            OUTPUT= my_proc_2
            );
I understand that INTERNALLENGTH is given in bytes, isn't it?
And second question - are there some functions, which I can use as
my_proc_* or must I write them by myself?
If so - how such functions look like?
    TIA
    Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------