Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer

On Mon, Jun 7, 2010 at 8:30 PM, Takahiro Itagaki
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> wrote:
>
> Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>> I noted on line 169 that max_avail is still an int ? Where else would
>> it be having problems ?
>
> It should not a problem because the local variable only stores byte
> size in a page. It will be at most only BLCKSZ (=8192).
>
> I wonder why you had "ERROR: value ... is out of range for type integer"
> message because we don't use any integer data types for sizes in
> pgstatindex. The error should have been thrown by SQL typin functions
> rather than C routines.
>
Takahiro,

Yes, this was the problem. I patched the C code but did not change the
functions.

Thanks,

Dave