Re: maxint reached? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: maxint reached?
Date
Msg-id 9249.1017847702@sss.pgh.pa.us
Whole thread Raw
In response to Re: maxint reached?  (Daniel Kalchev <daniel@digsys.bg>)
List pgsql-hackers
Daniel Kalchev <daniel@digsys.bg> writes:
> There is more to it:

> customer=# select max(oid) from croute;
>      max     
> -------------
>  -2144025472
> (1 row)

> How to handle this?

Use a more recent Postgres release.  max(oid) behaves as expected in
7.2.  Before that it was piggybacking on max(int4), which meant that
it chose the wrong value once you had any entries with the high bit
set...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Re : Solaris Performance - Profiling (Solved)
Next
From: Jessica Perry Hekman
Date:
Subject: Re: timeout implementation issues