À: John Brothers
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet: Re: [SQL] RE: [GENERAL] Problem with SELECT on large negative INT4
John Brothers <[EMAIL PROTECTED]> writes:
> I don't think that patch will work - Hiroshi whipped up that patch for
> me a week ago for a differen
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> Hiroshi neglected to mention that you'd probably need to drop and
> >> recreate the index after applying the patch; if it's indeed out of
> >> order, just patching the comparator bug isn't enough to fix it.
>
> > Does Hiroshi's patch get applied?
>
Applied.
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Nicolas Huillard
> >
> > I have a DB with is updated using MS Access. Primary keys are
> > Int4 with default random values ("Num_
I have a DB with is updated using MS Access. Primary keys are Int4 with default random
values ("NuméroAuto" + "Aléatoire" in Access).
The DB is migrated as-is in Postgres, with tbl_prod.cle_prod field containing values
from -2057496808 to 2139583719.
When I SELECT in the table, using the INT4 cl
