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

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "John Brothers" <johnbr(at)mindspring(dot)com>
Cc: <pgsql-general(at)hub(dot)org>, <pgsql-sql(at)hub(dot)org>
Subject: RE: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Date: 2000-01-28 04:40:56
Message-ID: 000a01bf6949$dde71020$2801007e@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-sql

> -----Original Message-----
> From: owner-pgsql-general(at)postgresql(dot)org
> [mailto:owner-pgsql-general(at)postgresql(dot)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(at)tpf(dot)co(dot)jp

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-01-28 04:49:14 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Previous Message John Brothers 2000-01-28 03:51:40 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-01-28 04:46:35 Re: [HACKERS] TODO list check
Previous Message Tom Lane 2000-01-28 04:39:59 Re: [HACKERS] TID clarification

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-28 04:49:14 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
Previous Message John Brothers 2000-01-28 03:51:40 Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4