Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer - Mailing list pgsql-hackers

From Dave Cramer
Subject Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer
Date
Msg-id AANLkTinjdJGGh0Ug4_KTh6wyVmaaww6QFmldwuJhHn86@mail.gmail.com
Whole thread Raw
In response to Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
On Mon, Jun 7, 2010 at 8:30 PM, Takahiro Itagaki
<itagaki.takahiro@oss.ntt.co.jp> wrote:
>
> Dave Cramer <pg@fastcrypt.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


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: walwriter not closing old files
Next
From: Leonardo F
Date:
Subject: Re: Git: Unable to get pack file