Re: maxint reached?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: maxint reached?
Дата
Msg-id 9249.1017847702@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: maxint reached?  (Daniel Kalchev <daniel@digsys.bg>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Re : Solaris Performance - Profiling (Solved)
Следующее
От: Jessica Perry Hekman
Дата:
Сообщение: Re: timeout implementation issues