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

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer
Дата
Msg-id AANLkTinjdJGGh0Ug4_KTh6wyVmaaww6QFmldwuJhHn86@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgstatindex still throws ERROR: value "3220078592" is out of range for type integer  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Список 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 по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: walwriter not closing old files
Следующее
От: Leonardo F
Дата:
Сообщение: Re: Git: Unable to get pack file