RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Дата
Msg-id 000a01bf6949$dde71020$2801007e@tpf.co.jp
обсуждение исходный текст
Ответ на Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4  (John Brothers <johnbr@mindspring.com>)
Список pgsql-sql
> -----Original Message-----
> From: owner-pgsql-general@postgresql.org
> [mailto:owner-pgsql-general@postgresql.org]On Behalf Of John Brothers
>
> I don't think that patch will work - Hiroshi whipped up that
> patch for me a
> week ago for a
> different problem - we have a table with duplicate primary keys, which
> seems to be
> an arithmetic overflow problem because the index key values can be both
> very large positive
> and very large negative numbers.
>

What was the result on your environment after applying my patch ?
My patch workded for your test case at least on my machine.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp

В списке pgsql-sql по дате отправления:

Предыдущее
От: John Brothers
Дата:
Сообщение: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4