Re: maxint reached?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Kalchev <daniel(at)digsys(dot)bg>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: maxint reached?
Date: 2002-04-03 15:28:22
Message-ID: 9249.1017847702@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Daniel Kalchev <daniel(at)digsys(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-04-03 15:37:07 Re: notification: pg_notify ?
Previous Message Jessica Perry Hekman 2002-04-03 15:26:04 Re: timeout implementation issues